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
Define mapping and session?
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
Can you generate sequence numbers without using the sequence generator transformation?
What is target load order?
What do think which one is the better joiner or look up?
What is meant by active and passive transformation?
What are the different transaction levels available in transaction control transformation?
Partition, what happens if the specified key range is shorter and longer
Explain the different lookup methods used in informatica?
Write the prerequisite tasks to achieve the session partition?
How you prepared reports for OLAP?
Explain the different kinds of facts.
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How to differentiate between the active and passive transformations?