Hi This is Sreenu

I will give you Interesting Informatica Scenarios, Real time questions

Informatica Interview questions

1.      How to generate sequence numbers in Informatica?

1.      Using Sequence Generator Transformation, connect NextVal port for the sequence of numbers

2.      Using Normalizer Transformation, connect GK_Id to get the sequence of numbers

3.      This can also be implemented by using Expression transformation

Create a variable port “V_Rec_Count” and expression is V_Rec_Count +1

Assign the V_Rec_count to another variable “V_Rec_Number” finally assign this variable to a output port “O_Record_Number” which will generate sequence of numbers.

SRC à SQ àEXP àTRG

In the Expression Transformation add a variable port “V_Rec_Count” and Output port O_Record_Number

The expression for the port V_Rec_Count = V_Rec_Count +1

Output port “O_CNT= V_Rec_Number

(Note: V_Rec_Number is variable port  to capture the V_Rec_Count otherwise it does not give expected result)

Explanation:

For the first record V_Rec_Count = Zero +1, V_Rec_Count will become 1

2^nd record V_Rec_Count =( V_Rec_Count =1)+1 , V_Rec_Count will become 2 and so on

By Sreenu Musham