Scenarios Set 1

1. How to remove duplicate records from a flat file while loading totarget instance.

Here I have posted 3 approach by using Sorter, Aggregator and Rank Transformations.

2. How to get top 3 salaried for each Department from Employee Table.

Here I have posted 2 approach by using Rank, Without Rank Transformation.

3. How to load 3 files from different location having similar definition into single target.

Here I have posted 3 approach Indirect Method, Union and Append Flat File.

4. How to pivot a single row into multiple rows.

Source Data:

DEPTNO	EMP NAME
10	CLARK
10	KING
10	MILLER
20	JONES
20	FORD
20	ADAMS
20	SMITH
20	SCOTT
30	WARD
30	TURNER
30	ALLEN
30	JAMES
30	BLAKE
30	MARTIN

Target Data:

DEPTNO	EMP NAME
10	CLARK|KING|MILLER
20	JONES|FORD|ADAMS|SMITH|SCOTT
30	WARD|TURNER|ALLEN|JAMES|BLAKE|MARTIN

5. How to convert single row from source to three rows in target.

6. How to load all duplicate rows and unique rows in to separate tables.

7. How to load only duplicate rows in one table and unique tows in another table.

8. How to separate Header, Detail and Trailer from a flat file.

9. How to create Header and Trailer records for a flat file.

10. How to remove footer from your file.

11. How to remove header from your file.

12. How to load 1^st half in one table and 2^nd half in another table.

13. How to load alternate record to target.

14. How to get top 5 records to target without using rank.

15. How to generate sequence number out sequence generator.

16. How to load ‘N’ no of records to the target.

17. How to concatenation of duplicate value by comma separation.

18. How to load Target table rows, with each row as sum of all previous rows from source table.

19. How to run a workflow on selected days of user defined days only.

20. How to generate target files with dynamic names.
Ref: https://gowtham-informatica-reference.blogspot.com/2013/04/transaction-control-transformation.html