Answer / Ankit Diyundi

DS Designer is a graphical user interface (GUI) provided by IBM DataStage for designing, developing, and debugging DataStage jobs.

What is meta stage?

1 Answers  

---

Explain ibm infosphere information server and highlight its main features?

1 Answers  

---

What are the types of hashed files in data stage

1 Answers  

---

how to define satge variables in transformer stage

2 Answers  

---

Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,

---

what is the use of surogate key in datastage

1 Answers   TCS,

---

what is the differeces between hash and modulus partition methods

4 Answers   TCS,

---

Is possible to create skid in dim,fact tables?

1 Answers   NTT Data,

---

how to unlock a locked job in datastage 8.0

3 Answers   HCL,

---

which cache supports connected & un connected Lookup

1 Answers   Wipro,

---

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers  

---

What is aggtorec restructure operator?

1 Answers  

---