i have 2 flat files one table contains duplicates another one
no duplicates.... so i need like this i don't want
duplicates...pl's give me ans...
Answer Posted / guest
with the help of joiner transformation we can join these two
flat file sources and reject the duplicate rows using normal
join in joiner transformation
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What is the surrogate key?
What is a router transformation?
What is aggregate cache in aggregator transformation?
Differentiate between reusable transformation and mapplet.
Write the prerequisite tasks to achieve the session partition?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
what is informatica metadata?
tell me the rules and responsblites in our project(my project is development)
What does role playing dimension mean?
can we override a native sql query within informatica? Where do we do it? How do we do it?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What are the types of data warehouses?
how many types of dimensions are available in informatica?
What is status code in informatica?
How many numbers of sessions can one group in batches?