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
- 24719 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 is a passive transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is informatica powercenter repository?
Enlist the differences between database and data warehouse.
What are multi-group transformations?
What are the types of schemas we have in data warehouse.
Difference between Data and Index Caches?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How can we use batches?
What is a rank transform?
How to use procedural logic inside infromatica?
How many types of sessions are there in informatica.please explain them?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Differentiate between a repository server and a powerhouse?
Enlist the tasks for which source qualifier transformation is used.
