Answer / 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

Answer / babu

Hi,

mapping:
Src==>SQ==>Exp(Nextval,Src_column)==>Rtr(3 Groups)==>T1,T2,T2
||
Seq


the above dagram represents the data flow from source to targets


Seq:Sequence generator from generate the sequence
numbers(1,2,3)only Max Val=3,please enable cycle option.

Rtr:Router transformation have 3 groups,Grp1,Grp2,Grp3
Grp1=1 ==>T1
Grp2=2 ==>T2
Grp3=3 ==>T3

please let me know if any thing wrong.

Is there any target staging area in informatica not staging area

0 Answers   Syntel,

---

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,

---

If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,

---

How to load last n records of file into target table - informatica

0 Answers   Informatica,

---

can we import source table without using source qualifier? if yes then how? if no then why?

2 Answers   Thomson Reuters,

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,

---

Can we use the mapping parameters or variables created in one mapping into another mapping?

1 Answers   Informatica,

---

can you avoid static cache in the lookup transformation? I mean can you

1 Answers  

---

when we dont use aggregator in mapping ?

2 Answers   CSC,

---

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,

---

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

0 Answers   IBM,

---

How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?

1 Answers   Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,

---