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 |
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
which is better perfomancewise lookup or joiner and why?can anyone give example?
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
How many ways are there to create ports?
what is the command to get the list of files in a directory in unix?
What is joiner change?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
What is complex mapping?
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
Explain the flow of data in Iinformatica?
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?