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

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,


We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  


why union is active transformation?

4 Answers   IBM,


What is union transformation?

1 Answers  


What are 2 modes of data movement in Informatica Server?

1 Answers   Informatica,


I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,


IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,


I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?

1 Answers  


What is rank transform?

1 Answers  


how to we create datamart?

2 Answers   HSBC,


What is lookup change?

1 Answers  


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1 Answers  


Categories