Hi Mapping: ======== Src==>SQ==>Exp==>Rtr(GRP1,GRP2,GRP3)

a soure table has 100 records how to load into 3 target
tables in a cumulative order
source target1 target2 target3
--------- -------------------------------------
1-100 1 2 3
4 5 6
- - -
98 99 100

Question Posted / babu

2 Answers
8220 Views
Cap Gemini, I also Faced
E-Mail Answers

Answer Posted / babu

Hi

Mapping:
========

Src==>SQ==>Exp==>Rtr(GRP1,GRP2,GRP3)==>T1,T2,T3
||
Seq

EXp:column1,Nexval(come from Seq Trans)

Rtr: have 3 groups
GRP1:MOD(Nextval,3)=1 ===>T1
GRP2:MOD(Nextval,3)=2 ===>T2
GRP3:MOD(Nextval,3)=0 ===>T3

Is This Answer Correct ?

23 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the shared cache and re-cache?

1076

How can one identify whether mapping is correct or not without connecting session?

1411

What is a mapplet/worklet in informatica?

1141

How can a transformation be made reusable?

1103

What is meant by a domain?

1099

Enlist the advantages of informatica.

1024

What is the difference between a connected look up and unconnected lookup?

936

difference between informatica 8.1.1 and 8.6

3647

What are the components of the workflow manager?

1100

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4696

Reusable transformation and shortcut differences

1805

Enlist some properties of sessions.

1044

update strategy transformation in informatica

1037

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2096

How to generate sequence numbers without using the sequence generator transformation?

1158