HI ,I think there is no need of sequence generator . sq->exp->tg1

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…….

Question Posted / ratalarayudu

7 Answers
10277 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

Please Help Members By Posting Answers For Below Questions

hi real timers . iam waiting for ur reply regarding ETL TESTING

2313

What is sequence generator transformation in informatica?

1127

What is a mapplet/worklet in informatica?

1244

how many types of dimensions are available in informatica?

1180

What are data-driven sessions?

1261

what is the -ve test case in your project.

2459

What will be the approach?

1039

Differentiate between joiner and lookup transformation?

1160

What is informatica? Why do we need it?

1164

What are connected or unconnected transformations?

1174

How we can create indexes after completing the load process?

1201

What happens when a session fails and you click on recover?

1172

Explain the different kinds of facts.

1022

explain one complex mapping with logic? sales project?

6738

Explain informatica architecture - version 8 / 9

1153