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 |
What are the components of workflow manager?
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
can you use flat file for lookup table?why?
Write the different tools in the workflow manager?
Explain one complecated mapping?
scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS
WAT IS TEXT LOAD?
What does role playing dimension mean?
What is mapplet in informatica?
Explain why we use partitioning the session in informatica?
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
How to improve the performance of a session using sorter transformation?