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

what is the difference between == and eq in UNIX shell scripting?

1500

---

What are the different kinds of views available in a datastage director?

1028

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2046

---

What is the importance of the exception activity in datastage?

1066

---

What steps should be taken to improve Datastage jobs?

1069

---

On which interface you will be working as a developer?

1042

---

How we can covert server job to a parallel job?

1143

---

How do y read Sequential file from job control?

15960

---

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

2293

---

What is a merge in datastage?

1265

---

how to delete one row in target dataset

3118

---

What are the job parameters?

1221

---

explain about citrix scheduling tool in datastage

2455

---

Describe routines in datastage? Enlist various types of routines.

1012

---

How can we improve the performance in datastage?

1101

---