col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq

9 Answers   Patni,

---

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

9 Answers   HCL,

---

Can you filter data in hashed file?

0 Answers  

---

What's the Main Function of the Staging area in DWH

3 Answers   Oracle,

---

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 modeling tool do you use?

6 Answers   HP,

---

1)Source file contains one record, I want 100 records in target file.

3 Answers  

---

how can u find out the datastage job is running on how many nodes

7 Answers   IBM,

---

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,

---

which dim, fact tables used in bank domain

1 Answers   HSBC, IBM,

---

If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers  

---

What are the benefits of datastage?

0 Answers  

---