How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
No Answer is Posted For this Question
Be the First to Post Answer
What is a rank transform?
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
What is the surrogate key?
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,
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
Roles and Responsibilties of Informatica Production Support Member?
suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?
In how many ways we can create ports?
Can anyone please distinguish what is Inner join and Outer join
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
WHat all joins are there in Source Qualifier?