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
- 21 Answers
- 34221 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / kt
Coolboy answer is correct , if you just want to join.
When u want to update the target then we hsould use DYNAMIC
cache.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the use of code page?
Explain target update override in informatica
Global and Local shortcuts. Advantages.
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is a sorter transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Can we create multiple integration service on single repository?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What do think which one is the better joiner or look up?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Define filter transformation?
Explain the code page compatibility?
what is the complex transformation you used in informatica
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
