Informatica Power Center Practice Exercises

Below are some exercises to improve ETL skills using Informatica Power Center.

1. Load a target table with truncate and load strategy.
2. Load a target table by Inserting/Updating using transformations Lookup and Update strategy.
3. Load a target table with Insert Else Update without using update strategy transformation
• This strategy is helpful if target table is huge and number changes going to target are less
4. Handle duplicates in Lookup transformation
• You could leave default properties to pickup the last value in duplicates
• Or you could change the properties to pick a value that is appropriate to your scenario
• Or you could also choose to get all matches including duplicates from lookup
5. Join data coming from multiple sources using Joiner transformation and load into a single target
6. Observe performance difference of using sorted input vs no sorted input in Joiner transformation
• Data can be sorted in source query if it is a database source
• Data can be sorted in sorter transformation if you cannot sort in source
• You may need to use sorter transformation if you are getting data from different source systems because they may return different output for same sort criteria (Ex: DB2 vs Oracle - Sort order for nulls/symbols is different between these two databases)