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

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

8 Answers   iNautix,


Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

5 Answers   DELL, TCS,


Could you explain what is enterprise data warehouse?

0 Answers  


how DTM buffer size and buffer block size are related

3 Answers   Wipro,


for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,






Define Pmrep command?

0 Answers  


In a table, 4 person having same salary. How to get Third person record only?

15 Answers  


why we use materialized view over view?

1 Answers   Zensar,


How might one distinguish in the case of mapping is right or not without associating session?

0 Answers  


How do you change a non-reusable transformation to reusable transformation?

0 Answers  


On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

6 Answers  


Explain what are the different versions of informatica?

0 Answers  


Categories