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

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2229

---

Distinguish between informatica & datastage. Which one would you choose and why?

1015

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1562

---

How to reverse the string using SQL?

1539

---

Explain how a source file is populated?

1377

---

What are the areas of application?

1157

---

What is ibm datastage?

980

---

How one source columns or rows to be loaded in to two different tables?

1138

---

What is the difference between the local container and shared container?

1113

---

how do u catch bad rows from OCI stage? And what CLI stands for?

2806

---

Define project in datastage?

1104

---

What are the different options associated with dsjob command?

1452

---

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

1047

---

What are some different alternative commands associated with "dsjob"?

1175

---

Differentiate between Join, Merge and Lookup stage?

1102

---