How do you Merge multiple Flat files for example 100 flat files
with out using Union T/F
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
4 yrs etl devloper roles and responsibilities?any body give solutions
When do you use sql override in a lookup transformation?
How to convert multiple rows to single row (multiple columns) in informatica
Is it possible to create multiple domains on a single Informatica server?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is the difference between a connected look up and unconnected lookup?
Explain the features of connected and unconnected lookup.
What is session task and command task?
What is the difference between stop and abort in informatica
Partition, what happens if the specified key range is shorter and longer
Explain what is informatica metadata and where is it stored?
How are indexes created after completing the load process?
How can you validate all mappings in the repository simultaneously?
Mention a few design and development best practices for informatica?
What are the differences between oltp and olap?