Answer Posted / p.ganesh

HAI THIS IS GANESH

IF SF CONTAINS 10 RECORDS USING SURRAGATE ID
GERNERATOR,TRANSFORMER STAGAE WE CAN SPLIT THE DATA INTO
MULTIPLE TARGERS

SF--SURRAGATE ID GENERATOR--TRANSFORMER--TGT1
--TGT2
--TGT3
--TGT4
--TGT5
IN SURRAGATE ID GENERATOR WE CAN GENERATE THE SID VALUES,NEXT
IN TRANSFORMER STAGE WE CAN CLINK ON CONSTRAINT THEN APPLY
THE EXPRESSION AS
IF MOD(DLLINK.SID,5)=1 THEN 1 ELSE 0,THIS IS FOR TGT1
IF MOD(DSLINK.SID,5)=2 THEN 1 ELSE 0,THIS IS FOR TGT2
IF MOD(DSLINK.SID,5)=3 THEN 1 ELSE 0 ,THIS IS FOR TGT3
IF MOD(DSLIND.SID,5)=4 THEN 1 ELSE 0,THIS IS FOR TGT4
IF MOD(DSLINK.SID,5)=0 THEN 1 ELSE 0,THIS IS FOR TGT5


HERE MOD(DSLINK,SID,NO.OF OUTPUT)=CONDITION
THEN
1,6 TO TGT1
2,7 TO TGT2
3,8 TO TGT3
4,9 TO TGT4
5,10 TO TGT5
IF U HAVE ANY DOUBT PLS CONTACT ME
MOBILE:9538631567

Can you explain kafka connector?

1284

---

What is meta stage?

1166

---

Triggers,VIEW,Procedures

1207

---

table actions available in oracle connector?

1589

---

What is the difference between orabulk and bcp stages?

1009

---

What is the sortmerge collector?

1111

---

What is job control?

1095

---

In Datastage, how you can fix the truncated data error?

1142

---

in oracle target stage when we use load option and when we use upsert option?

2256

---

What is the difference between the local container and shared container?

1080

---

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1861

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5100

---

What is the difference between server job and parallel jobs?

1134

---

Is it possible to query a hash file?

1985

---

What are the main features of datastage?

1258

---