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
- 34138 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / srik
5m => 5 million recors.
1) Since target side records are very huge compared to
the source, caching is not preffred. so No caching.
2) Again with no caching we can accomplsh this in 2 ways
a) By Joiner
b) Unconnected lookup
but as unconnected lookup is not in answers is in the
option, Joiner is the answer
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
in reporting we add some new objects,how we get the count of the newly added objects to the report
Why is sorter an active transformation?
How to extract sap data using informatica? What is abap? What are idocs?
How to do unit testing in informatica? How to load data in informatica ?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Define update strategy?
can we override a native sql query within informatica? Where do we do it? How do we do it?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What are the types of presistent cache in look up tr.
How to use procedural logic inside infromatica?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How many transformations can be used in mapplets.
What is the sequence generator transformation in informatica?
What is the command used to run a batch?
What are the different options available for update strategy?
