i have ten flat files with same structure,if
i want to load it to single target,and mapping needs to
should show only one source.what will be the steps to taken
to achieve it?/
Answer Posted / arnab
Concat all the files using a Unix shell script to create a
new file and use this as the source file
If you use windows create a dos batch script
Then call the Unix shell script before calling the session
in the workflow , so that the process is automated
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the types of caches in lookup? Explain them.
Enlist the differences between database and data warehouse.
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is parallel processing in informatica?
What is meant by active and passive transformation?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Explain pmcmd command usage in informatica
How you prepared reports for OLAP?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How to update source definition?
How can we handle two sessions in informatica?
What are the modules in Power Center
Enterprise data warehouse your projects phase by phase explain?
explain one complex mapping with logic? sales project?