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 is apt_config in datastage?

1081

---

How will you move hashed file from one location to another location?

2090

---

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

969

---

How to perform incremental load in datastage?

1122

---

What is use Array size in datastage

1717

---

What is the roundrobin collector?

1033

---

what is flow of project?

1927

---

how can we create rank using datastage?what is the meaning of rank?

8705

---

How you Implemented SCD Type 1 & Type 2 in your project?

4072

---

Highlight the main features of datastage?

1086

---

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

1224

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3261

---

How you can fix the truncated data error in datastage?

1673

---

what is the use of skid in reporting?

2307

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3604

---