How do you Merge multiple Flat files for example 100 flat files
with out using Union T/F
- 4 Answers
- 17102 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / phani
By using File List we can Merge more than one Flat file.
when we are importing more than one flat file we should Set
the Source Property as INDIRECT,where default property ll
have DIRECT. and we should give the file,which ll have the
adresses of all the Flat files which we are going to merge.
| Is This Answer Correct ? | 20 Yes | 4 No |
Post New Answer View All Answers
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is dimensional table? Explain the different dimensions.
how to create user defined function (udf) in informatica
list out all the transformations which use cache?
What is meant by lookup transformation?
What are the uses of etl tools?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is a joiner transformation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What are the designer tools for creating transformations?
What is informatica etl tool?
What is the benefit of partitioning a session?
Enlist the various types of transformations.
How does the aggregator transformation handle null values?
What is decode in informatica?
