1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

how can import the data from the flat files?

Question Posted / guest

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

how to sort date field in infomatica?

2 Answers  

whatis the default data driven operation in informatica

2 Answers  

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  

what is diff b/t sorter t/r and agg have the option sorter property...

0 Answers  

Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers  




how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

What is the difference between Active and Passive transformation?

0 Answers   Informatica,

What is pmcmd command?

0 Answers  

When the informatica server marks that a batch is failed?

2 Answers  

how tokens will generate?

0 Answers  

two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

2 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories