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 |
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
How to create a non-reusable instance of reusable transformations?
what is diff between grep and find
performance tuning of Informatica
when we use dynamic lookup,if condition matches what will be the o/p?
what is the difference between stop and abort?
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
what is filelist concept in informatica
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is transformation?
What is workflow monitor?
What is the filename which you need to configure in UNIX while installing infromatica?