My i/p is 1,2,3,4,5,6,7,8,9,10………..
o/p to be populate in two tables as below.
o/p1: 10,20,30,40,50,60,70,80,90…….
o/p2: 11,21,31,41,51,61,71,881,91…….
Answer Posted / firdaus
src-->exp1-->target1
src-->exp2-->target2
In exp1 drag i/p port,then take o/p port
0/p=i/p||0
In exp2 drag i/p port,then take o/p port
0/p=i/p||1
thn link o/p ports of exp1 & exp2 to target1 & target2.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
While importing the relational source definition from the database, what are the metadata of source that will be imported?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
what are 3 tech challenges/ common issues you face?
According to his methodology what all you need before you build a datawarehouse
What is a predefined event?
tell me the rules and responsblites in our project(my project is development)
Could you explain what is enterprise data warehouse?
How to extract sap data using informatica?
What are the different clients of powercenter?
What is the reusable transformation?
What are the various types of transformation?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is option by which we can run all the sessions in a batch simultaneously?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
In how many ways we can create ports?