Interested to Buy Any Domain ? << Click Here >> for more details...
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?/
- 5 Answers
- 12185 Views
- L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anoymous
Create a file system with extension .txt in that copy all
the 10 flat file paths.
Now at session level
source type : indirect
File directory : File system path
source file name: Name of file system.txt
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / 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 |
Answer / prasuna
Hi shiva,thanks for giving answer..can u elaborate the
answer??
| Is This Answer Correct ? | 0 Yes | 0 No |
Make a note of the quantity vaults made in informatica?
Difference Between ETL & ELT?
What is transformation?
Explain 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?
On which transformations you created partitions in your project?
What are ETL Tools?
What are the Differences between static cache and dynamic cache?
How to call shell scripts from informatica?
What is the way to execute pl/sql script using informatica mapping?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
HOW TO DELETE A RECORD FROM FLAT FILE
What is substr in informatica?
Teradata 
