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
What are the tuning techniques you applied during your last project
What is Cognos script editor?
Explain target update override in informatica
Under which circumstances, informatica server creates reject files?
What is the difference between source qualifier transformations source filter to filter transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How to load a Dimension ? and how to load a fact table?
How to generate sequence numbers without using the sequence generator transformation?
How can we use mapping variables in informatica?
Why is sorter an active transformation?
What is union transformation?
Write the advantages of partitioning a session?
How does a rank transform differ from aggregator transform functions max and min?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How many numbers of sessions can one group in batches?