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!!

Answers were Sorted based on User's Feedback



Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how..

Answer / 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

Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how..

Answer / rana

There is not limitation of source in informatica, but there
is limitation in workspce in warehouse designer.

If there is more Flat file having same streucture then use
inbdirect approach to load.

If there is more Flat file but with not same structure then
you will have to create the process.

let me know if you still any pblm
Rana

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

In joiner, how to load Master table in Target?

2 Answers  


Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai

1 Answers   Infosys, Saksoft,


What are parallel querys and query hints?

1 Answers  


write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

3 Answers   iGate,


in which situations do u go for scds ?

3 Answers   TCS,






In any project how many mappings they will use(minimum)?

1 Answers  


What is the format of informatica objects in a repository?

0 Answers  


where to select code page option?

2 Answers   TCS,


Why sorter is an active transformation?

0 Answers   Informatica,


What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,


WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?

1 Answers   Wipro,


If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,


Categories