Hi, I am new to Informatica, What is a flat file and how to
use flat file in infomratica please help me.
Answer Posted / rabikant thakur
Flat file like Notepad,MS-Word Flat file does maintain the
referential integrity and seprated with some delimeter like
comma and tab
| Is This Answer Correct ? | 10 Yes | 10 No |
Post New Answer View All Answers
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is a repository? And how to add it in an informatica client?
What are the different transaction levels available in transaction control transformation?
Differences between connected and unconnected lookup?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Define sessions in informatica etl?
Explain the use of aggregator cache file?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What does “tail –f” command do and what is its use as an Informatica admin.
Briefly describe lookup transformation?
Explain scd type 3 through mapping.
which one is better performance wise joiner or look up