Answer Posted / pooja

Sort Stage
__________________________________________________________

1. Complex Sorts
2. When explicit Sorting Stage is required.
3. When Key change or cluster Key change columns are
required. As based on it the data needs to be filtered out
ahead in the job.

Sort performed in the input of few stages or Insort Stage
__________________________________________________________

1. Simple Sort
2. When there is no need to define a Sort stage explicitly.
3. There's no such option as key change here.


need to use
stage explicitly.

What are the primary usages of datastage tool?

1128

---

How to RD using transformer?

1475

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2074

---

Differentiate between hash file and sequential file?

1129

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1467

---

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

1112

---

How many Key we can define in remove duplicate stage?

1441

---

Enlist various types of routines in datastage.

1328

---

How complex jobs are implemented in datstage to improve performance?

1095

---

What is the difference between hashfile and sequential file?

1318

---

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

857

---

I have a few records just I want to store data in to targets cycling way how?

2414

---

Can you implement SCD2 using join, transformer and funnel stage?

1604

---

What is the difference between server job and parallel jobs?

1200

---

Can you explain engine tier in information server?

1185

---