DataStage Scenario based Interview Questions

1 Answers  

---

Explain usage analysis in datastage?

0 Answers  

---

what is snow flack schema?

2 Answers  

---

What is quality stage?

0 Answers  

---

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

0 Answers   NTT Data,

---

How did you reconcile source with target?

2 Answers   HP,

---

Explain ibm infosphere information server and highlight its main features?

0 Answers  

---

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 the use of invokation id

2 Answers   IBM,

---

How can you find out whether datastage process is running or not in unix?

3 Answers   Accenture,

---

How can we do null handling in sequential files?

3 Answers   Reliance,

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

0 Answers   IBM,

---