Can anyone know that what is the Source File limitation in
Informatica?
To be more precise ..
how many flat file we can use as a source in a mapping if..
1) The Structure of flat files are same
&
2) If the Structure of flat files are different.
Please explain the procedure also if it dosn't bother one much!!

Answer Posted / srinu

There is no limit for no of sources,

Flat file(same syntax,Diff Syntax) and Relational also.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you load only null records into target?

736


How many transformations can be used in mapplets.

1452


What are the reusable transformations?

692


What are the main features of Oracle 8i with context to datawarehouse?

1675


can we override a native sql query within informatica? Where do we do it? How do we do it?

595






What happens to map if we alter the datatypes between source and its corresponding source qualifier?

596


Make a note of the quantity vaults made in informatica?

547


What are batches?

617


What is the Rank index port in Rank transformation?

666


What are the differences between oltp and olap?

546


What is sorter transformation?

576


What are the differences between a connected lookup and unconnected lookup?

641


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1025


Tell me about Propagate functions in informatica

520


What are the different options available for update strategy?

570