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
- 25065 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 expression transformation?
What are session parameters ? How do you set them?
How would you copy the content of one repository to another repository?
expain about the tune parameters?
What is meant by target load plan?
What is the difference between a connected look up and unconnected lookup?
Plz can any one say me how to get the informatica certification materials and dumps
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What are connected or unconnected transformations?
Why do we need informatica?
What is substr in informatica?
What is workflow monitor?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
tell me the rules and responsblites in our project(my project is development)
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
