Why is meant by direct and indirect loading options in sessions?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
How can you recover the session in sequential batches?
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
difference between stop and abort
In update strategy target table or flat file which gives more performance ? why?
How will the document be delivered to me?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
what is upstream and downstream transformation?
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
what are cost based and rule based approaches and what is the difference?
Could any one to tell Fact table Partitioning?
In which circumstances that informatica server creates Reject files?
How can repository reports be accessed without sql or other transformations?