How to delete duplicate records in a flat file source?
Answer Posted / bsgsr
conncet the flat file to sorter transformation and select
distinct option.
Is This Answer Correct ? | 17 Yes | 6 No |
Post New Answer View All Answers
Clarify the aggregator change?
What is informatica powercenter repository?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
Which are the different editions of informatica powercenter that are available?
What is confirmed fact in dataware housing?
Explain the informatica workflow?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is the use of transformation?
How to go to the older version for a mapping?
Partition, what happens if the specified key range is shorter and longer
How to open an older version of an object in the workspace?
How to use pmcmd utility command?
What is the need for an etl tool?
Under what condition selecting sorted input in aggregator may fail the session?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.