how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?
Answer Posted / radhakrishnansk
Considering the source as flat file.
src-->Src qual ---> sorted transfomation -->trgt
|
|---> trgt
In sorted transformation, we can choose distict in
properties. So the duplicate is avoided.
correct me if I am wrong
| Is This Answer Correct ? | 1 Yes | 11 No |
Post New Answer View All Answers
How to open an older version of an object in the workspace?
What are the steps involved in the migration from older version to newer version of Informatica Server?
How many transformations can be used in mapplets.
What's the layout of parameter file (what does a parameter file contain?)?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the difference between writing a joiner query in ANSI style and THETA style?
Explain the types of lookup transformation?
where to store informatica rejected data?
According to his methodology what all you need before you build a datawarehouse
Why do you use Mapping Parameter and mapping variable?
server hot-ws270 is connect to Repository B. What does it mean?
Explain the scenario which compels informatica server to reject files?
What are the types of schemas we have in data warehouse.
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.