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
Please ignore my first ans. i miss to write "not"
Here is currect ans:
Flat file like Notepad,MS-Word Flat file does not maintain
the referential integrity and property like RDBMS and
seprated with some delimeter like
comma and tab
Is This Answer Correct ? | 21 Yes | 4 No |
Post New Answer View All Answers
What do you mean by filter transformation?
What are the different components of powercenter?
Explain the difference between a data warehouse and a data mart?
What are the tasks that can be performed using sq?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Which development components of informatica have the highest usage?
What is decode in informatica?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Enlist some properties of sessions.
What are the static cache and dynamic cache in informatica?
What are data-driven sessions?
Slowly changing dimensions, types and where will you use them
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is meant by active and passive transformation?