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

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1398

---

How rejected rows are managed in datastage?

1496

---

What is a ds designer?

1058

---

how do u catch bad rows from OCI stage? And what CLI stands for?

2789

---

Why do we use exception activity in Datastage?

1288

---

How do you start developing a datastage project?

1089

---

What is the difference between informatica and datastage?

1203

---

What is the command line function to import and export the ds jobs?

1134

---

Difference between in process and inter process?

1211

---

what is the custome stage in datastage? how can we impliment that one? plz tell me

2348

---

What can we do with datastage director?

1223

---

Can you explain players in datastage?

1178

---

Nls stands for what in datastage?

1182

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2366

---

If you want to use the same piece of code in different jobs, how will you achieve it?

1134

---