Answer / chinna kannapuram

Just select those two fields as key fields in Sort stage or
in any other stage like Transformer stage. it will work.

SOURCE LIKE I_D,F1,F2 --------- 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 O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y

4 Answers  

---

How to reverse the string using SQL?

0 Answers   CTS,

---

How a routine is called in datastage job?

0 Answers  

---

Name the different sorting methods in datastage.

0 Answers  

---

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers   CTS,

---

---

Two source files contains same meta data third file contains different data types can I funnel that file.

2 Answers  

---

What is RCP?

2 Answers   TCS,

---

What are the stages in datastage?

0 Answers  

---

How to generate surrogate key without using surrogate key stage?

6 Answers   IBM,

---

plz tell me some dimentional and fact table names in banking project?

2 Answers   Virtusa,

---

we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

1 Answers   HSBC, NTT Data,

---

How and where you used hash file?

0 Answers  

---