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......

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2799

---

What are the components of datastage?

1112

---

project Steps,hits, Project level HArd things,Solved methods?

2107

---

Name the third party tools that can be used in datastage?

1064

---

Have you used Unstructured data?

1303

---

how to add a new records into source?

1981

---

What is the use of hoursfromtime() function in transformer stage in datastage?

1048

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2217

---

Why do we use link partitioner and link collector in datastage?

1116

---

What is the purpose of pivot stage and types of containers in datastage

1028

---

Where do you see different stages in the designer?

1076

---

What are the different plug-ins stages used in your projects?

1062

---

What is meta stage?

1168

---

What are the different common services in datastage?

1270

---

How do you start developing a datastage project?

1089

---