Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 3 Answers
- 7655 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 power designer data modeling software?
What is fact? What are the types of facts?
Give the benefits of data integration suite?
how do u handle performance issues in Informatica . where can u monitor the performance ?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is a mapping, session, worklet, workflow, mapplet?
List few etl bugs?
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?
Difference between flat files and relational sources?
What is etl process. How many steps etl contains explain with example?
Do we need an etl tool?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
