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 / ratalarayudu
HI ,I think there is no need of sequence generator .
sq->exp->tg1
->tg2
In exp take 2 port
out_1=input_port*10
out_2=input_(port*10)+1.
Link out_1 to tgt1
Link out_2 to tgt2.
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
Explain what transformation and how many are there in informatica?
Why filter transformation is an active one?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
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 is the fact table?
How to call shell scripts from informatica?
what are 3 tech challenges/ common issues you face?
Explain the pipeline partition with real time example?
What happens when a session fails and you click on recover?
Write the prerequisite tasks to achieve the session partition?
What is dimensional table?
Which development components of informatica have the highest usage?
What all are steps in up gradation of Informatica server?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Under what conditions selecting sorted input in aggregator will still not boost session performance?