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
Briefly explain the aggregator transformation?
Explain about cumulative Sum or moving sum?
what is the -ve test case in your project.
What is union transformation?
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
How to update or delete the rows in a target, which do not have key fields?
How does a rank transform differ from aggregator transform functions max and min?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are the different components of powercenter?
What are multi-group transformations?
How to create the source and target database connections in server manager?
What is target designer and target load order?
How big was your fact table
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are batches?