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
How can repository reports be accessed without sql or other transformations?
How to open an older version of an object in the workspace?
What is a filter transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is the different lookup cache(s)?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is a repository? And how to add it in an informatica client?
Explain sessions?
What are the tasks that can be performed using sq?
How can a transformation be made reusable?
What is meant by LDAP users?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
what is unit testing?tell me proceedure
While importing the relational source definition from the database, what are the metadata of source that will be imported?
On which transformations you created partitions in your project?