Real Time Senarios

1. Convert single row from source to three rows in target.
2. Separating duplicate and non-duplicate rows to separate tables.
   
   
3. Retrieving first and last record from a table/file 
   

   
   
4. Remove header and footer from your file 
5. Sending first half record to one target and second half of record to another target 
   

   
   
6. Sending alternate record to target 
7. Get top 5 records to target without using rank 
   

   
   
8. Extracting every nth row 
   

   
   
9. Sending records to target tables in cyclic order 
10. Concatenation of duplicate value by comma separation 
    

    
    
11. Lead and Lag in informatica level.
12. Produce files as target with dynamic names 
    

    
    
13. Using mapping parameter and variable in mapping 
14. Removing '$' symbol from salary column 
    
    
15. sending data one after another to three tables in cyclic order 
    

    
    
16. Minus operation on flat file
    

    
    
17. Insert and reject records using update strategy 
18. Count the no of vowel present in emp_name column 
19. Add custom message to session log file.
    

    
    
20. How to load multiple files with different structure.
    

    
    
21. Demonstrate Incremental load.
    

    
    
22. Demonstrate Incremental Aggregation.
    

    
    
23. Separate even odd records
    

    
    
24. Concurrent execution of a workflow.
    

    
    
25. Rows to column conversion
    

    
    
26. Column to Rows Conversion
    
    
27. Constraint Based Loading
    

    
    
28. SCD TYPE1 
    

    
    
29. SCD Type2 
    

    
    
30. SCD Type3 
    

    
    
31. Unit Testing
32. Error Handling