Answer / datastage4you

Use dsjob command

What is RCP

5 Answers   CGI, CTS,

---

What is the difference between odbc and drs stage?

1 Answers  

---

how to define satge variables in transformer stage

2 Answers  

---

How do u convert the columns to rows in datastage?

1 Answers  

---

What is active and passive stage?

1 Answers  

---

How to display all the duplicate records from the oracle Table?

3 Answers   IBM,

---

WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers   Wipro,

---

how to design the change capture stage in(data stage parallel jobs) type 2

2 Answers   IBM,

---

How can u write exception handling in seq file????

2 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,

---

CHANGE CAPTURE

1 Answers   CTS,

---

souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 Answers  

---