Interested to Buy Any Domain ? << Click Here >> for more details...
What is best approach to load 100 different source files
(Different structure) to differet target tables ?
- 2 Answers
- 10845 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mahesh manam
For different source and different target you can make all
the mappings in ONE mapping.
And create a session for that mapping and you can call it.
If you have any constraints to load from particular target
and than some other target like wise any priority than
mention target load in mapping level
(Mappings --> target load plan --> give your priority)
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / manojkumar challagundla
Yes you are correct.
Am just checking here like is there any better approach.
Thank you
| Is This Answer Correct ? | 1 Yes | 0 No |
when informatica 8 series released ?
My source table having some records ,i want load 1st record and last record into one target?
Explain the tuning lookup transformation - informatica
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
If I have a index defined on target table and if set it to bulk load will it work ?
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
how the server recognises , if the session fails after loading the 100 records in to the target
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
Could you explain what is enterprise data warehouse?
in which situations do u go for scds ?
wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35
Teradata 
