Interested to Buy Any Domain ? << Click Here >> for more details...
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
- 7 Answers
- 21946 Views
- iNautix, I also Faced
- E-Mail Answers
Answer Posted / harish konda
Give the SQL query to sort the data in source in source
qualifier t/f.
And then connect to exp t/f and add one more port (say flag)
to generete numbers like, when prev row and current row
values are same, then increment number, or else give 1.
And next connect to Filter t/f and give the condition in
filter as flag=1.
Then rout the data to target.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the performance considerations when working with aggregator transformation?
Briefly explain the aggregator transformation?
How can we improve session performance in aggregator transformation?
What are the differences between oltp and olap?
write a query to retrieve the latest records from the table sorted by version(scd)
Write the unconnected lookup syntax?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is a joiner transformation?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How can we create index after completion of load process?
What are the various types of transformation?
What are mapplets?
Differentiate between joiner and lookup transformation?
wat are deployement groups in informatica, how it will be used for developers
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
