Interested to Buy Any Domain ? << Click Here >> for more details...
Why is meant by direct and indirect loading options in sessions?
- 4 Answers
- 24403 Views
- I also Faced
- E-Mail Answers
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 |
Explian the Process of deployment groups in informatica
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
What is rank index in rank transformation?
update strategy transformation in informatica
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to list Top 10 salary, without using Rank Transmission?
Can we change Dynamic to Static or Persistent cache? If so what happens?
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
Write the program through which the records can be updated?
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
How do you load alternate records into different tables through mapping flow?
Teradata 
