Where do we use mapping variables in informatica?
No Answer is Posted For this Question
Be the First to Post Answer
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out
How do you load first and last records into target table?
Explain lookup transformation source types in informatica
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
How to load a Dimension ? and how to load a fact table?
how to load duplicate row in a target
Explain the features of connected and unconnected lookup.
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,