Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicates in FF and oracle both
- 3 Answers
- 7284 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / priyank
For FF, place an Aggregator transformation, do a group by
on all the columns, it will remove the duplicates from the
flat file.
In Oracle, use distinct in SQ sql override to remove the
duplicates.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between a data warehouse and a data mart?
What are roles and groups and benefits of using them?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Define pmcmd command?
What is union transformation?
What is main use of mapplet?
tell me about your project functionality
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the issues you have faced in your project? How did you overcome those issues?
During the running session, output files are created by informatica server. Enlist few of them.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is the difference between informatics 7x and 8x and what is latest version?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is Cognos script editor?
