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  

---

what is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,

---

What are routines in datastage? Enlist various types of routines.

0 Answers  

---

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers  

---

what is operator combinality in datastage?

1 Answers   TCS,

---

---

tell me abt Datastage trigger?

1 Answers   HP, IBM,

---

How complex jobs are implemented in datstage to improve performance?

0 Answers  

---

Enlist various types of routines in datastage.

0 Answers  

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

0 Answers  

---

Define ds designer?

0 Answers  

---

how to sort two columns in single job in datastage.

1 Answers   TCS,

---

Name the command line functions to import and export the DS jobs?

0 Answers  

---