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
What are mapplets? How is it different from a Reusable Transformation?
How is union transformation utilized?
what is the -ve test case in your project.
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explain the features of connected and unconnected lookup.
What is informatica?
Separate from a database, an information bazaar, and an information stockroom?
in reporting we add some new objects,how we get the count of the newly added objects to the report
waht type of interface is used for testing the data in informatica
Can you generate sequence numbers without using the sequence generator transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Is it possible to revert a global repository to local one and why?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?