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 happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is rank index in rank transformation?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is the status code in stored procedure transformation?
What are the modules in Power Center
How can we use mapping variables in informatica? Where do we use them?
As union transformation gives UNION ALL output, how you will get the UNION output?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Define the various join types of joiner transformation?
How do you use reject loader.
design of staging area?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How would you join a node to the already existing domain?