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 |
Two Default User groups created in the repository are ____ and ______
How to delete duplicate row using informatica?
Which kind of index is preferred in DWH?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is the scenario which compels informatica server to reject files?
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?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Describe the impact of several join conditions and join order in a joiner transformation?
wht is cdc?how to use it in creation of mappings?
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.
Explain in detail about scd type 1 through mapping.
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