Interested to Buy Any Domain ? << Click Here >> for more details...
What is the method of loading 5 flat files of having same
structure to a single target and which transformations I can
use?
- 8 Answers
- 25290 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / arnab
Use Union transformation , if you do not want to use Union
and if your informatica runs on Unix , then create a shell
script to concatenate these files and create a single
file , you can call this shell script before you call the
session in the workflow
If you use windows create and dos batch script and do the
same as above
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the issues you have faced in your project? How did you overcome those issues?
What are the prerequisite tasks to achieve the session partition?
Explain sql transformation in script mode examples in informatica
Why is sorter an active transformation?
How do you set a varible in incremental aggregation
What are the features of complex mapping?
What is different between the data warehouse and data mart?
What is the need for an etl tool?
Does an informatica transformation support only aggregate expressions?
What does cheating measurement mean?
How to implement security measures using repository manager?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is a snowflake schema?
How are the sources and targets definitions imported in informatica designer?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
