Why is meant by direct and indirect loading options in sessions?
Answer Posted / 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 View All Answers
How can we handle two sessions in informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
How to open an older version of an object in the workspace?
Write the unconnected lookup syntax and how to return more than one column.
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How to extract sap data using informatica? What is abap? What are idocs?
How do you migrate data from one environment to another?
Briefly explain the aggregator transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain sessions and how many types of sessions are there?
What is a joiner transformation and why it is an active one?
In how many ways we can create ports?
What are the popular informatica products?