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 |
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
what is the use of Data Mart?
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
How to generate sequence numbers?
What is the target load order?
What is substr in informatica?
difference between informatica 8.1.1 and 8.6
What is a difference between complete, stop and abort?
What are the types of maping in Getting Started Wizard?
What is complex mapping?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani