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
- 40086 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / kareem
we need to use dynamic lookup because when 110 rows are
coming from the source and 5 m rows are already existing in
the target here the function of the dynamic lookup is used
to share the source rows and insert into the target.
Hope answer your question.
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
What is the benefit of partitioning a session?
explain one complex mapping with logic? sales project?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Why update strategy and union transformations are active? Explain with examples.
write a query to retrieve the latest records from the table sorted by version(scd)
What is a snowflake schema?
Repository user profiles
What are Dimensional table?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
whats the logic to load the lower level of granularity of data to fact table.
Differentiate between joiner and lookup transformation?
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
Can you generate sequence numbers without using the sequence generator transformation?
What do you mean by worklet?
How to Create a folder using pmrep command?
