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
How can repository reports be accessed without sql or other transformations?
State the limitations where we cannot use joiner in the mapping pipeline?
What is persistent lookup cache?
How to call shell scripts from informatica?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
During the running session, output files are created by informatica server. Enlist few of them.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is dynamic cache?
How to load the data from a flat file into the target where the source flat file name changes daily?
What are the different versions of informatica?
expain about the tune parameters?
What is decode in informatica?
design of staging area?
Explain lookup transformation source types in informatica
Define mapplet?