Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 40646 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / amarnath
using the joiner is right I have faced similar kind of
scenario in my project. if u use static it has to cache all
the 5m records and then compare the each incoming records
which will de-grade the performance, hence designate the
master record with less no of rows in joiner which is a gud
practice.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
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 will the document be delivered to me?
What is InformaticaPowerCenter?
What is exclusive and normal mode for repository services?
How do you load first and last records into target table?
What is dimensional table?
Differentiate between Load Manager and DTM?
How many number of sessions can one group in batches?
Explain pushdown optimization and types 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
What are the performance considerations when working with aggregator transformation?
What is the cumulative sum and moving sum?
What is the need of etl tools?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
how to load rows into fact table in data warehouse
