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
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 size of u r source(like file or table)?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are the limitations of joiner transformation?
Define mapplet?
What could be the possible resons of locks by user?
what is degenerated dimension?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Tell me about MD5 functions in informatica
Can we create a node as a gateway node and the same node can be assigned to a grid?
Explain pushdown optimization $pushdownconfig parameter - informatica
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Different sorts of metadata that stores in the storage facility?
How to start a workflow using pmcmd command?
What is a joiner transformation and why it is an active one?