Why is meant by direct and indirect loading options in sessions?

Answers were Sorted based on User's Feedback



Why is meant by direct and indirect loading options in sessions? ..

Answer / raj

we use file type direct when we are loading single file into
target. we use Indirect when we want to load multiple files
through single session.

Is This Answer Correct ?    21 Yes 1 No

Why is meant by direct and indirect loading options in sessions? ..

Answer / prashant

When we are using the Direct option at the session
level,then we are loading only single file.
But when we are using Indirect option, then we can load
multiple files also.For this we have give a list file
(.list) path in the session which will contain the names of
the files need to be loaded.

Is This Answer Correct ?    15 Yes 1 No

Why is meant by direct and indirect loading options in sessions? ..

Answer / pradeep

we use file type direct when we are loading single file into
target. we use Indirect when we want to load multiple files
through single session in the mapping

Is This Answer Correct ?    7 Yes 1 No

Why is meant by direct and indirect loading options in sessions? ..

Answer / srikanth chowdary

when you are using the direct method option in session side that time your loading only single file into target and when you are using indirect method that time you can create LIST.txt file then you can pass multiple files into target in a single session but need to same structure in files

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

Two Default User groups created in the repository are ____ and ______

2 Answers  


How to delete duplicate row using informatica?

0 Answers  


Which kind of index is preferred in DWH?

2 Answers  


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,


What is the scenario which compels informatica server to reject files?

0 Answers  






Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers  


Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers  


wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,


Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers  


Explain in detail about scd type 1 through mapping.

0 Answers  


wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,


Categories