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 / srinu
Joiner :- Catch Performance will work based on
Master,Detail Column,Data catch,Index
catch ,Catch Size also.
(Process Begins with Condition,Comparing, Indexing)
No Catch :-With out Catch, its not easy find(5 records)
Relavtive Data.
Static ;- Catch will Keep the Target Rows to Compare with
Sourece Rows.
(Process Begin with Condition,Comparing).
Dynamic :- The Catch Data will be Update on DataFlow
also. ,,,
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
pmscmd startworkflow -sv
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How can you differentiate between powercenter and power map?
Explain the etl program with few examples.
Define pmcmd command?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How to do unit testing in informatica?
Differentiate between router and filter transformation?
What are the uses of etl tools?
How to join three sources using joiner? Explain though mapping flow.
What is meant by target load plan?
what is the difference between informatica6.1 and infomatica7.1
Explain informatica architecture - version 8 / 9
How to improve the performance of a session using sorter transformation?