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
- 12121 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 |
Explain lookup transformation in informatica
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
how you will maintain version?
What is flashback table ? Advance thanks
How can we delete duplicate rows from flat files?
I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?
What is exclusive and normal mode for repository services?
What are the uses of etl tools?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How to enter same record twice in the target table,explain?
How to display First letter of Names in Caps?
How do you create single lookup transformation using multiple tables?
Teradata 
