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
- 21453 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
Do you find any difficulty while working with flat files as source and target?
What is the use of an aggregator cache file?
Where can we find the throughput option in informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Design time, run time. If you don't create parameter what will happen
What are the settings that you use to configure the joiner transformation?
Why update strategy and union transformations are active?
What is the Rank index port in Rank transformation?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What are the different types of repositories created using informatica?
How many types of sessions are there in informatica.please explain them?
What all join we can perform in LOOKUP transformation?
What does refresh system mean, and what are its distinctive choice?
Describe data concatenation?
