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

why u go for dimensions ?

3 Answers   TCS,


Kimball and Inmon methodologies?

2 Answers  


i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,


why we are using surogate key in real time give me explanation

2 Answers   TCS,


Tell me about Propagate functions in informatica

0 Answers  






How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,


pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

0 Answers   HCL,


SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,


By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  


Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

11 Answers   IBM,


How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,


Categories