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 |
Why filter transformation is an active one?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
how do u use sequence created in oracle in informatica? Explain with an simple example
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
Can we call a stored procedure from a unix script which is run using command task
What is factless fact schema?
without update strategy how to insert &update?
I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?
Tell me about MD5 functions in informatica
In informatics server which files are created during the session rums?