Answer Posted / vinod upputuri

Appreciate your Answer but it was wrong..because if you are using Agregator stage it will give only unique records with record count. so how can u print all the duplicate records.


in the above senario:

input to agregator stage: 251,251,456,456,951,985
i used count rows.
so, the o/p is 251,2
456,2
951,1
985,1
if U use the Filter stage then what is the output:
O/P1:
251
456

O/P2:
951
985

Unfortunately this is not the answer we are required...

This is not as simple as U think...i implemented it before posting!!!!!

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1467

---

How to read the length of word in unix?

1325

---

What are the types of containers in datastage?

1153

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2403

---

Differentiate between operational datastage (ods) and data warehouse?

1133

---

What are the types of containers?

1162

---

Explain Quality stage?

1103

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

2409

---

How you can fix the truncated data error in datastage?

1698

---

Can you explain repository tables in datastage?

1358

---

Nls stands for what in datastage?

1155

---

Can you explain engine tier in information server?

1080

---

What are sequencers?

1071

---

What are the different types of lookups in datastage?

1021

---

Differentiate between hash file and sequential file?

1023

---