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
What is the meaning of decode in informatica?
What is enterprise data warehousing?
Enterprise data warehouse your projects phase by phase explain?
How do you convert single row from source into three rows into target?
If informatica has its scheduler why using third party scheduler?
How to create the source and target database connections in server manager?
What is rank transform?
Please let me know how to make Data masking in informatica..
Where do we use mapping variables in informatica?
What is informatica worklet?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Explain sessions?
How can we delete duplicate rows from flat files?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How to load last n records of file into target table - informatica