How to eliminate duplicates in FF and oracle both
Answer Posted / priyank
For FF, place an Aggregator transformation, do a group by
on all the columns, it will remove the duplicates from the
flat file.
In Oracle, use distinct in SQ sql override to remove the
duplicates.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you load only null records into target?
What is the fact table?
Design a mapping to load a target table with the following values from the above source?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Explain about Informatica server process that how it works relates to mapping variables?
How would you join a node to the already existing domain?
What is meant by incremental aggregation?
How do you load only null records into target? Explain through mapping flow.
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is complex mapping?
what is song in infrmatica...?
What is enterprise data warehousing?
what is $$$$?
How can we handle two sessions in informatica?
What is an Integration service in Informatica?