Answer / mobashshar

you can speed up the read operation of reference hash file
link by pre loading the hash file in memory.

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers   Cap Gemini, IBM,

---

On which Dimension Table you implemented SCD Type in your Project

0 Answers  

---

IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 Answers  

---

Notification Activity

0 Answers   CTS,

---

where the log files or tables can store in DS?

2 Answers   IBM,

---

---

HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?

1 Answers   HCL, IBM, Infosys,

---

Which type of joins Merge stage can support?

7 Answers   IBM,

---

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

8 Answers   Cognizant, HCL, TIAA CREF,

---

What is a merge?

0 Answers  

---

What is the project in datastage?

0 Answers  

---

Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,

---

Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

1 Answers   SS Solutions,

---