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


Please Help Members By Posting Answers For Below Questions

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5811


What is the need of etl tools?

609


What are the types of schemas we have in data warehouse.

531


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

1687


Explain the informatica workflow?

589






What is target designer and target load order?

655


What are the main issues while working with flat files as source and as targets ?

654


How to partition the Session?

648


What are the components of Informatica? And what is the purpose of each?

623


Explain what transformation and how many are there in informatica?

486


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?

5576


Name the different lookup cache(s)?

709


What is a dimensional model?

583


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3510


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2136