how can u avoid duplicate rows in flat file?
- 4 Answers
- 9529 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sunil
In a sorter transformation select distinct option to avoid
duplicates in a flat file
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / ramanaiah
without using sorter,and aggregrator transformations.we can
useing dynamic lookup to avoid duplicate rows.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sbvp
i also faced this question . i said that i am using sorter
and agg group by options. but they ask me again with out
using sorter and agg how can u eliminate the duplicates? so
, plz give me a answer for that
| Is This Answer Correct ? | 0 Yes | 0 No |
What are session parameters ? How do you set them?
how do u fnd the duplicate rows and how to delete the duplicate rows?
What is the reusable transformation?
According to his methodology what all you need before you build a datawarehouse
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
what is diff between IN and EXIT commands
What is the Difference between PowerPlay transformer and power play reports?
What is the procedure for creating independent data marts from informatica 7.1?
After we make a folder shared can it be reversed?Why?
What does command task mean?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Teradata 
