Answer / Sarika Chaudhari

IBM DataStage Flow Designer is an Eclipse-based development environment for designing, developing, and debugging DataStage jobs. It provides a more advanced GUI compared to DS Designer.

What is ibm datastage flow designer?

1 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 orabulk stage?

1 Answers  

---

what is the main differences between Lookup, Join and Merge stages?

9 Answers   HCL,

---

Tell me Wt main advantage of Stage varibles? Project level hints?

4 Answers   Hexaware,

---

What are constraints and derivations?

1 Answers  

---

Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?

3 Answers   IBM, TCS,

---

What are the unit test cases you used in your project?

1 Answers   CSC, HY,

---

Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises

1 Answers   TCS,

---

How to reverse the string using unix?

1 Answers   CTS,

---

guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.

2 Answers   TCS,

---

what is the use of surogate key in datastage

1 Answers   TCS,

---