from Source 100 rows are coming, on target there are 5 m
rows which options is better to match data
1. Joiner
2 No cache
3. Static
4. Dynamic
Answer Posted / chitti
use joiner tr............
you have to take source as master table and target as detail
table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are roles and groups and benefits of using them?
How do you load alternate records into different tables through mapping flow?
What are the uses of etl tools?
difference between informatica 8.1.1 and 8.6
What do you mean by filter transformation?
What are the limitations of joiner transformation?
Explain pushdown optimization $pushdownconfig parameter - informatica
How to improve the performance of a session using sorter transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is a joiner transformation?
What is a surrogate key?
What are the measure objects?
How to extract sap data using informatica? What is abap? What are idocs?
While importing the relational source definition from the database, what are the metadata of source that will be imported?