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
- 12409 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 |
Why update strategy and union transformations are active?
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
Why sorter is an active transformation?
Explain how many types of dimensions are available in informatica?
What are events in workflow manager?
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
What is the format of informatica objects in a repository?
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What if the source is a flat-file?
what is parameter file?
Teradata 
