In update strategy target table or flat file which gives
more performance ? why?
Answer Posted / sanjay
Flate file give better performance bcz Retrival of data
from flat file is fast then relation database
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Define filter transformation?
While migrating the data from one environment to another environment how would you manage the connections?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How to load the data from a flat file into the target where the source flat file name changes daily?
How we can create indexes after completing the load process?
can u give example for factless fact table
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is status code in informatica?
Can you use flat files in Mapplets.
What are the settings that you use to configure the joiner transformation?
What is expression transformation?
What does refresh system mean, and what are its distinctive choice?
What is the procedure for creating independent data marts from informatica 7.1?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.