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 |
what is junk dimension
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
why we are using level option in normalizer transformation
HOW TO DELETE A RECORD FROM FLAT FILE
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
in which situations do u go for snowflake schema ?
Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500
How many ways are there to create ports?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.