Explain sql transformation in script mode examples in informatica


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

what is runtime variable?

3 Answers   TCS,


can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,


How to eliminate 1st and last rows from the source and load the inbetween rows.

5 Answers   Syntel,


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,


In target table how to display the system time

1 Answers  






Why we select the table which has minimum number of records as Master table in joiner?

4 Answers   HG, UST,


How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

1 Answers  


Parameter and variable differences

0 Answers  


what is fact and what types of fact tables is there

4 Answers   Cap Gemini,


What is Data Caches size?

0 Answers   Informatica,


tell me about your project functionality

0 Answers  


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  


Categories