My i/p is like below
1,2,3,4,5,6,7,8,9,10....100
I want that to be populated in two o/p as below
o/p-1:
10,20,30,40,50,60,70,90...
o/p-2:
11,21,31,41,51,61,71,81,91....
How to do it in ingotmatica...

Answers were Sorted based on User's Feedback



My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below ..

Answer / karthika

firstly multiply each input with 10. Then will get the output as 10,20,30,40.....100.
secondly add 1 to each output of the first output then will get the 11,21,31......101.

Is This Answer Correct ?    1 Yes 0 No

My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below ..

Answer / sri

use seq genarator t/r start with 10 increment with 10 end with 100
use one mor seq t/r start with 11 increment with 10 end with 101

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is data driven in informatica

5 Answers   IBM,


can u give example for factless fact table

2 Answers   TCS,


What is sequence generator transformation in informatica?

0 Answers  


What is up date strategy and what are the options for update strategy?

2 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,






Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,


What are the reusable transformations?

0 Answers   Informatica,


what happens if you try to create a shortcut to a non- shared folder?

1 Answers  


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

0 Answers   TCS,


Explain transaction control transformation in informatica

0 Answers   Informatica,


Explain in detail about scd type 1 through mapping.

0 Answers  


What is router transformation

4 Answers   CSC,


Categories