Interested to Buy Any Domain ? << Click Here >> for more details...
How can we eliminate duplicate rows from flatfile,explain?
- 3 Answers
- 11815 Views
- I also Faced
- E-Mail Answers
Answer Posted / veera reddy
By Using Aggregator transformation by selcting the group by
option or using sorter by using distinct option or by using
dynamic lookup by selecting distinct option.
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How to elaborate powercenter integration service?
What are batches?
What are the components of the workflow manager?
Can informatica load heterogeneous targets from heterogeneous sources?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What are the components of workflow manager?
What is a code page?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How many dimensions are there in informatica?
What is aggregator transformation in informatica?
How would you join a node to the already existing domain?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Differentiate between Load Manager and DTM?
