we have 6 records in source , i need 2nd record in one
target and 5th record in one target or 2nd & 5th record in
same target.
Answer Posted / lvpr
Another way is to use rank t/r and load data to target by
filtering 2 and 5 rows.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How to generate or load values in to the target table based on a column value using informatica etl tool.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are the restrictions of union transformation?
How to join three sources using joiner?
Enlist the differences between database and data warehouse.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is the scenario which compels informatica server to reject files?
How can we remove the duplicates from flat file source?
What is resilience time?
What are the differences between oltp and olap?
What are the differences between a connected lookup and unconnected lookup?
How to load a Dimension ? and how to load a fact table?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Explain the shared cache and re-cache?
what is $$$$?