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


Please Help Members By Posting Answers For Below Questions

How can repository reports be accessed without sql or other transformations?

728


State the limitations where we cannot use joiner in the mapping pipeline?

547


What is persistent lookup cache?

603


How to call shell scripts from informatica?

577


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?

600






During the running session, output files are created by informatica server. Enlist few of them.

539


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

2279


What is dynamic cache?

614


How to load the data from a flat file into the target where the source flat file name changes daily?

575


What are the different versions of informatica?

678


expain about the tune parameters?

1884


What is decode in informatica?

654


design of staging area?

1588


Explain lookup transformation source types in informatica

699


Define mapplet?

627