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

Where the datastage stored his repository?

1042

---

what is ds administrator used for?

1137

---

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2204

---

why do u need the IOS upgradation in a FC switch

2244

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2246

---

How do you schedule or monitoring the job?

1165

---

What are the steps needed to create a simple basic datastage job?

1188

---

Whats difference betweeen operational data stage (ods) and data warehouse?

1086

---

Explain connectivity between datastage with datasources?

953

---

Explain the situation where you have applied SCD in your project?

2004

---

Why we use surrogate key?

1180

---

Define Job control?

1092

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3227

---

Why do we use exception activity in Datastage?

1253

---

How many types of hash files are there?

1147

---