What is best approach to load 100 different source files
(Different structure) to differet target tables ?
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 |
How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica
Can we use the mapping parameters or variables created in one mapping into another mapping?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance
Using Expression transformation how to remove duplicate records from a relational source?
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
What is an incremental loading? in which situations we will use incremental loading
Differentiate between joiner and lookup transformation?
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
How will u pas the data with out debugger?