Answer Posted / siva

seq.file-->copy-->agg
! !secondary link
!.....>join-------->filter-->t1
primarylink !---->t2
agg:countrows
give condition in filter
count=1-->t1
count<>1-->t2

How many areas for files does datastage have?

1154

---

What is a quality stage in datastage tool?

1078

---

Where the datastage stored his repository?

1089

---

Define Routines and their types?

1187

---

What is a ds designer?

1070

---

Differentiate between data file and descriptor file?

1060

---

What are the various kinds of the hash file?

1151

---

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

808

---

What is the flow of loading data into fact & dimensional tables?

1063

---

Differentiate between datastage and informatica?

1182

---

What is difference between join, merge and lookup stage?

1098

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2046

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2722

---

Which algorithm you used for your hashfile?

1183

---

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)

2730

---