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...
Answer Posted / 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 |
Post New Answer View All Answers
What is a passive transformation?
How to partition the Session?
What is a sequence generator transformation?
What is the advantage of informatica?
Please let me know how to make encryption and decryption with example?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is fact table? Explain the different kinds of facts.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is joiner transformation?
Design time, run time. If you don't create parameter what will happen
How to configure mapping in informatica?
What is the use of code page?
What are the advantages of using informatica as an etl tool over teradata?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is exclusive and normal mode for repository services?