Interested to Buy Any Domain ? << Click Here >> for more details...
How do you remove duplicate records in informatica?
- 1 Answers
- 1319 Views
- I also Faced
- E-Mail Answers
Answer / lahari
There are multiple ways to do it.
1.if source is RDBMS then we can filter by selecting distinct option.
2.In sorter transformation select distinct.
3.In Aggregator transformation select all ports as group by key.
| Is This Answer Correct ? | 0 Yes | 0 No |
how to load duplicate row in a target
How to load last 10 records of flat file in to the target?
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
What is mapping debugger?
what is the command to get the list of files in a directory in unix?
What is informatica?
Define pmcmd command?
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
How many ways a relational source definition can be updated and what are they?
What is pmcmd command?
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
Teradata 
