Answer Posted / d.bharath

Take source and copy,aggregate,transformer and lookup,
1) give one copy output link to aggr,

2)In arggr perform count rows,

3)And in transformer check constrains count>1,count>2

4)And lookup the result of count>2 with the second output
link of copy stage.the you will get the all repeated rows
into on one output dataset.

Is possible to create skid in dim,fact tables?

2586

---

What are the functionalities of link collector?

1034

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

749

---

How do u convert the columns to rows in datastage?

1139

---

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2658

---

What are the steps required to kill the job in Datastage?

1148

---

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

2090

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2207

---

CHANGE CAPTURE

1256

---

What is the use of datastage director?

971

---

Is it possible to query a hash file?

1950

---

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

2748

---

What is the use of datastage designer?

1086

---

root tree will find which is server job and which is parallel job?

1881

---

Describe the main features of datastage?

1035

---