What is best approach to load 100 different source files
(Different structure) to differet target tables ?
- 2 Answers
- 9885 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Slowly changing dimensions, types and where will you use them
what is the -ve test case in your project.
In informatics server which files are created during the session rums?
What are data-driven sessions?
whats the logic to load the lower level of granularity of data to fact table.
Describe data concatenation?
how to create user defined function (udf) in informatica
waht type of interface is used for testing the data in informatica
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?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are the differences between oltp and olap?
How to generate sequence numbers using expression transformation?
Differentiate between router and filter transformation?
What is an active transformation?
