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
- 10973 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
what is SDLC way of code development?
What is workflow monitor?
How to update or delete the rows in a target, which do not have key fields?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Describe an informatica powercenter?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the settings that you use to configure the joiner transformation?
Informatica Checkpoints
Is it possible to use a client with different version than that of its Informatica server?
What is parallel processing in informatica?
What will be the approach?
How does a sorter cache works?
Explain dynamic target flat file name generation in informatica
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
