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


Please Help Members By Posting Answers For Below Questions

What do you mean by filter transformation?

554


What are the different components of powercenter?

582


Explain the difference between a data warehouse and a data mart?

600


What are the tasks that can be performed using sq?

615


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?

1749






Which development components of informatica have the highest usage?

596


What is decode in informatica?

656


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

696


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?

1464


Enlist some properties of sessions.

628


What are the static cache and dynamic cache in informatica?

718


What are data-driven sessions?

713


Slowly changing dimensions, types and where will you use them

1272


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.

1870


What is meant by active and passive transformation?

584