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
Explain the difference between mapping parameter and mapping variable?
What is a passive transformation?
how many types of dimensions are available in informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is Index Caches size?
What is sq transformation?
Make a note of the quantity vaults made in informatica?
How many number of sessions can one group in batches?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How big was your fact table
What is an aggregator transformation?
How can you validate all mappings in the repository simultaneously?
Explain the use of aggregator cache file?
Explain the etl program with few examples.
What is the sql query overwrite in source qualifier in informatica