If I am having 6 flat files in data. How can you load the
data at a time

Answers were Sorted based on User's Feedback



If I am having 6 flat files in data. How can you load the data at a time..

Answer / sankar

for that 6 flat files make a one list file,then enter the
that 6 flat file paths in list file.
then session level select the type: inderect path:list file
patha filename:list

Is This Answer Correct ?    21 Yes 0 No

If I am having 6 flat files in data. How can you load the data at a time..

Answer / ravindra.15aug

By using file list or indirect method

Is This Answer Correct ?    18 Yes 0 No

Post New Answer

More Informatica Interview Questions

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?

6 Answers  


Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?

4 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,


if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,


what is target update override and when we use it?

2 Answers   TCS,






Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,


Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

3 Answers   Infosys,


Why touse stored procedure in ETL Application?

2 Answers  


what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,


I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  


if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   BirlaSoft, Genpact, L&T, Syntel,


i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,


Categories