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
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 |
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
how can we check whether a particular cache is static or dynamic?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How do you take back up of repository?
how to load only the first and last record of a flat file into the target?
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
How can we get multiple output values using an unconnected lookup transformation?
write a query for how to eliminate the duplicate rows without using distinct?
How to call shell scripts from informatica?
waht is dataware house
What if the source is a flat-file?