Explain the mapping variable usage example in informatica
No Answer is Posted For this Question
Be the First to Post Answer
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
What is data movement mode in Informatica and difference between them?
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
How to use pmcmd utility command?
i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81
How to create or import flat file definition in to the warehouse designer?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
4 Answers CompuSoft, EDS, TCS,
In update strategy target table or flat file which gives more performance ? why?
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
what is shortcut in informatica? difference between shortcut,reusable object?