1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

In Datastage, we have row generator stage to generate dummy
row.

Is there any such transformation in Informatica.

Thanks in advance,
Kumar

Question Posted / guest


In Datastage, we have row generator stage to generate dummy row. Is there any such transformati..

Answer / sudheer113

Yes,Sequence Generator.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

3 Answers   TCS,

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

Can you start a session inside a batch individually?

2 Answers  

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  

How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!

2 Answers  

Define error Threshold?

1 Answers  

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 Answers   Amdocs,

What are differences between Informatica 7.1 and 6.1

3 Answers  

following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers   Patni,

(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance

1 Answers  

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

For more Informatica Interview Questions Click Here
Categories