Hi, I am new to Informatica, What is a flat file and how to
use flat file in infomratica please help me.

Answer Posted / venkadesh

IT IS NOTHING BUT TEXT DOCUMENT SO WE TAKE AS SOURCE FILE.
AFTER THAT WE LOAD IN SOURCE TABLE. BY CLICKING SOURCE MENU
AND SELECT IMPORT FILE

Is This Answer Correct ?    3 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the meaning of decode in informatica?

646


can we override a native sql query within informatica? How do we do it?

652


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.

773


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

1651


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1850






How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

695


What do you understand by term role-playing dimension?

574


Which files are created during the session rums by informatics server?

706


Different qualification between a related rotate toward the sky and isolates look upward?

553


What are Dimensional table?

617


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

1743


Differentiate between a repository server and a powerhouse?

577


In development project what is the process to follow for an etl developer from day1

1281


What is an expression transformation in informatica?

517


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

632