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 |
Informatica and datawarehousing courses in Pune?
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
What are the guidelines to be followed while using union transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How to identify this row for insert and this row for update in dynamic lookup cache
What is the procedure for creating independent data marts from informatica 7.1?
how can u avoid duplicate rows in flat file?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
Do joiner transformation use cache? If so describe?
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
I have 1200 records how can u send it in aggregator with good performance issues?