How do you import and export data into 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,

---

Why we need datasets ratherthan sequential files?

5 Answers  

---

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?

4 Answers   HCL,

---

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers   IBM,

---

What are the different types of lookups in datastage?

0 Answers  

---

What are the some differences between 7.x and 8.x version of datastage?

0 Answers  

---

How to generate surrogate key without using surrogate key stage?

6 Answers   IBM,

---

What is the difference between validate and compile?

1 Answers   CTS,

---

To see hidden files in LINIX?

0 Answers   CTS,

---

can a fact table contains textual information

6 Answers   HCL, HCL BSERV, IBM,

---

In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?

2 Answers   Polaris,

---