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 is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Why update strategy and union transformations are active? Explain with examples.
What are the types of lookup transformation?
What is different between the data warehouse and data mart?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Please let me know how to make Data masking in informatica..
What all are steps in up gradation of Informatica server?
What is domain and gateway node?
What are the main features of Oracle 8i with context to datawarehouse?
What is informatica metadata and where is it stored?
In informatics server which files are created during the session rums?
What are the types of schemas we have in data warehouse and what are the difference between them?
What's the layout of parameter file (what does a parameter file contain?)?
What is the function of look up transformation?
What is transformation?