how can import the data from the flat files?

Answers were Sorted based on User's Feedback



how can import the data from the flat files?..

Answer / teja_dwh

the file has to be exist in your machine.then import file same
as database table.to import specify the path.

Is This Answer Correct ?    2 Yes 0 No

how can import the data from the flat files?..

Answer / immu

Source Analyzer---->click on import from file---->select file

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

why we need informatica

2 Answers   HCL,


i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,


When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,


Enlist few areas or real-time situations where informatica is required.

0 Answers  


what are the transformations that restricts the partitioning of sessions?

1 Answers  






my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,


Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,


scd methodology?

2 Answers  


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

0 Answers  


explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,


Can we get 1st record through Informatica(without sequence number).

0 Answers  


What is confirmed dimension and fact?

7 Answers  


Categories