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 / 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 View All Answers
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is the need for an etl tool?
What is the difference between informatics 7x and 8x and what is latest version?
Can we override a native sql query within informatica?
During the running session, output files are created by informatica server. Enlist few of them.
Mention a few design and development best practices for informatica?
How can one identify whether mapping is correct or not without connecting session?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
When do you use sql override in a lookup transformation?
Explain the types of lookup transformation?
How to improve the performance of a session using sorter transformation?
What is the function of union transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is the status code in stored procedure transformation?