Interested to Buy Any Domain ? << Click Here >> for more details...
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…….
- 7 Answers
- 10073 Views
- Accenture, I also Faced
- E-Mail Answers
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
How to update source definition?
How to elaborate tracing level?
How you know when to use a static cache and dynamic cache in lookup transformation?
How to go to the older version for a mapping?
What is a filter transformation and why it is an active one?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What are the performance considerations when working with aggregator transformation?
Can you use flat files in Mapplets.
How many number of sessions can one group in batches?
What is sequence generator transformation in informatica?
What is rank transform?
Define filter transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is data caches/ index caches?
What are the types of caches in lookup? Explain them.
