Answer Posted / chandra swain

source-->transformersatage--->dataset1
---->dataset2
----->dataset3
double click on transformerstage,copy the input to output link
i.e(dataset1,dataset2,dataset3),then go to constraint part of the transformer stage ,we will find three constraint tabs,

in 1st constraints tabs write down--> column=1orcolumn=2orcolumn=3orcolumn=10orcolumn=11orcolumn=12
then go to 2nd constraints tabs --->write similarly
column=4orcolumn=5orcolumn=6orcolumn=13orcolumn=14orcolumn=15
,then go to 3rd constraints tab and click on otherwise/Log

go to dataset1,click on partitioning tab,select partition type:=hash,then click on check box(i.e perform sort)..
similarly ,go to dataset2,dataset3,and mention all the above technic...

i hope u got solun......

Define ds designer?

1328

---

what is the use of surogate key in datastage

2365

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

3019

---

What is the difference between passive stage and active stage?

1643

---

Why do you need stage variables?

1230

---

What are the some differences between 7.x and 8.x version of datastage?

1306

---

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

1558

---

Differentiate between operational datastage (ods) and data warehouse?

1233

---

How many types of views are there in a datastage director?

1340

---

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

1171

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3215

---

What is the use of datastage designer?

1218

---

How many types of stage?

1227

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3182

---

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

1218

---