how to import multiple flat files in to single target where
there is no common column in the flat files

Answers were Sorted based on User's Feedback



how to import multiple flat files in to single target where there is no common column in the flat f..

Answer / kotesh

using filelist concept, we can acheive this one.

Is This Answer Correct ?    9 Yes 2 No

how to import multiple flat files in to single target where there is no common column in the flat f..

Answer / ramana sreepathi

in workflow session properties in Mapping tab
in properties
choose Source filetype Indirect
Give the Source filename : <file_path>

This <file_path> file should contain all the multiple files
which you want to Load

Is This Answer Correct ?    9 Yes 2 No

Post New Answer

More Informatica Interview Questions

how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers   CTS,


what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,


What are the new features of informatica 9.x at the developer level?

0 Answers  


What are the advantages of using informatica as an etl tool over teradata?

0 Answers  


my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 Answers   Zensar,


why we use stored procedure transformation?

4 Answers   IBM,


What is resilience time?

0 Answers  


what is unit testing?tell me proceedure

0 Answers   L&T, UST,


what is metadata?

6 Answers  


how can we perform incremental aggregation?explain with example?

9 Answers   IBM, TCS,


In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,


Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,


Categories