What is the method of loading 5 flat files of having same
structure to a single target and which transformations I can
use?
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 3 tech challenges/ common issues you face?
What are the databases that informatica can connect to windows?
tell me the rules and responsblites in our project(my project is development)
difference between informatica 8.1.1 and 8.6
Mention few power centre client applications with their basic purpose?
without table how to come first record only in oracle?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Can we create two repositories on same database instance in oracle?
What are the reusable transformations?
How can we use batches?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is the use of target designer?
What are the basic requirements to join two sources in a source qualifier transformation using default join?