how can u avoid duplicate rows in flat file?
Answers were Sorted based on User's Feedback
Answer / sunil
In a sorter transformation select distinct option to avoid
duplicates in a flat file
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / ramanaiah
without using sorter,and aggregrator transformations.we can
useing dynamic lookup to avoid duplicate rows.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sbvp
i also faced this question . i said that i am using sorter
and agg group by options. but they ask me again with out
using sorter and agg how can u eliminate the duplicates? so
, plz give me a answer for that
| Is This Answer Correct ? | 0 Yes | 0 No |
In which circumstances that informatica server creates Reject files?
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
Is it possible to revert a global repository to local one and why?
How to load the source table into flat file target(with columns) in informatica?
Using Expression transformation how to remove duplicate records from a relational source?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
AT the max how many transformations and mapplets can we use in a mapping ?
1 Answers Cap Gemini, Cognizant,
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
define galaxy repository in informatica
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,