how will you remove the duplicate records from flat file
without using sorter?
Answer Posted / krishnakanthch
We can use the option 'SELECT DISTINCT' in the source
qualifier.
Anybody please tell me whether this works or not.
| Is This Answer Correct ? | 5 Yes | 23 No |
Post New Answer View All Answers
Briefly explain the aggregator transformation?
What is status code in informatica?
How to Create a folder using pmrep command?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Explain scd type 3 through mapping.
Clarify the utilization of aggregator cache record?
what is the difference between informatica6.1 and infomatica7.1
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is Session and Batches?
When do you use sql override in a lookup transformation?
What is a standalone command task?
What are roles and groups and benefits of using them?
Explain the difference between mapping parameter and mapping variable?
What are pre and post-session shell commands?
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