Interested to Buy Any Domain ? << Click Here >> for more details...
how can u avoid duplicate rows in flat file?
- 4 Answers
- 10753 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
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 reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
what is left outer join?
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
How do you change a non-reusable transformation to reusable transformation?
what is target update override and when we use it?
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
How will you combine 3 different sources with a single source?
how to we create datamart?
Teradata 
