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
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 |
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 |
i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?
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.
Could you explain what is enterprise data warehouse?
how DTM buffer size and buffer block size are related
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.
Define Pmrep command?
In a table, 4 person having same salary. How to get Third person record only?
why we use materialized view over view?
How might one distinguish in the case of mapping is right or not without associating session?
How do you change a non-reusable transformation to reusable transformation?
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?
Explain what are the different versions of informatica?