How do you avoid duplicate records with out using source
qualifier,expression,aggrigator,sorter and lookup
transformations ?
Answer Posted / prasad
u can use unix command in pre session as sort -u file1
>newfile
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
What are the different ways to implement parallel processing in informatica?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What happens when a session fails and you click on recover?
How to generate or load values in to the target table based on a column value using informatica etl tool.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How to create the source and target database connections in server manager?
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.
Explain Dataware house architecture .how data flow from intial to end?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What differs when we choose the sorted input for aggregator transformation?
Briefly explain the aggregator transformation?
What is informatica metadata and where is it stored?
What do you understand by term role-playing dimension?
Define Pmrep command?
what is song in infrmatica...?