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 |
what is data driven in informatica
can u give example for factless fact table
What is sequence generator transformation in informatica?
What is up date strategy and what are the options for update strategy?
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.
Label in Informatica. How to remove existing Label.
What are the reusable transformations?
what happens if you try to create a shortcut to a non- shared folder?
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.
Explain transaction control transformation in informatica
Explain in detail about scd type 1 through mapping.
What is router transformation