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 ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

828


How we can create indexes after completing the load process?

924


Name at least 5 different types of transformations used in mapping design and state the use of each.?

900


How to load the data from people soft hrm to people soft erm using informatica?

782


What are the different types of transformation available in informatica.

831


Explain the code page compatibility?

840


How can we handle two sessions in informatica?

802


What is the difference between a repository server and a powerhouse?

1161


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1870


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

775


Sequence generator, when you move from develoment to production how will you reset

1673


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

966


What is a sequence generator transformation?

777


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6004


How can you generate reports in informatica?

769