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 / swapnil
It should be un chached coz by this way the 100 records
will directly compare at the database level hence no cache
will get created and will take less time not to create
cache and compare the source records at the db level.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the differences between source qualifier and joiner transformation?
Tell me about MD5 functions in informatica
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
explan ur project architecture?
I have a flat file, want to reverse the contents of the flat file
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How many ways a relational source definition can be updated and what are they?
Why do we need informatica?
What is the difference between router and filter?
How to load last n records of file into target table - informatica
What does cheating measurement mean?
What is meant by query override?
Explain the types of lookup transformation?
Quickly characterize reusable change?
Explain what are the different types of transformation available in informatica.