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
- 21500 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
difference between informatica 8.1.1 and 8.6
what is Active lock explain
Explain pmcmd command usage in informatica
Whats the difference between informatica powercenter server, repositoryserver and repository?
Parameter and variable differences
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is decode in static cache?
can we override a native sql query within informatica? Where do we do it? How do we do it?
what are factless facts? And in which scenario will you use such kinds of fact tables.
how tokens will generate?
What is update strategy transform?
How union transformation is used?
How many ways a relational source definition can be updated and what are they?
Describe data concatenation?
What are the popular informatica products?
