How do you remove duplicate records in informatica?
- 1 Answers
- 1026 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 |
what are challenges that you faced in testing? give solution to it?
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
How the Informatica Server reads perameter file?
what is degenerated dimension
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
Differentiate between router and filter transformation?
Which are the different editions of informatica powercenter that are available?
what is the difference between lookupoveride and joiner?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is the sequence generator transformation in informatica?
Teradata 
