Eliminating of duplicate records without using dynamic lookups
Answer Posted / pooja ahmed
1. you can you use sorter transformation .... in that you
select distinct option
2. use agg trans .... in that go for group by
usi8ng above metyhod you can remove duplicate rec...
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
What are various etl tools in the market?
flat filevalidation in informatica
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
Which transformation we use to convert 'NA' to 'Not Available'
hoe to access second value in mapping parameter if it is having more than one value ?????????????
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
When do we go for the tools in the market?
What is Data Vault???
how do u really know that paging to disk is happening while u are using a lookup transform?
What is the difference between project backlog and product backlog?
What is tracing level and what are the types?
what is the difference between cubes and package in cognos
what is the meant by Normalization and de-normalization?
what happens if the info.server doesn't find the session parameter in the parameter file?