Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 3 Answers
- 7806 Views
- I also Faced
- E-Mail Answers
Answer Posted / jakka
Below are the ways to eliminate the duplicate records:
1.Select distinct in source qualifier
2.Based on your requirement,select and give number of
sorted ports in source qualifier and need to override the
query using order by cluase. Then use aggregator and select
sorted input as given and use group by ports
3. Use sorter to sort data and then use aggregator as
mentined in point 2.
4.Use sorter to sort data and check distinct in soter
properties.
Hope this will help you...
Jakka
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain about etl data integration software?
Explain the use lookup tables and Aggregate tables?
Can we create Hierarchies in generic datasources?
how many maximum session supports to multiload in teradata ??
What are three tier systems in etl?
Explain me ETL project architecture in Detail?
what are the facilities provided by data warehouse to analytical users?
what is session partitioning?
Mention few test cases and explain them?
What is lookup table in etl testing?
what is an ETL or ETT? And what are the different types?
What is meant by incremental load?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
What is full load & incremental or refresh load?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
