Answer / datastage4you

You can generate seq no by, column generator or transformer

http://goo.gl/atN4AT
www.datagenx.net

What are the types of jobs we have in datastage?

0 Answers  

---

What is orabulk stage?

0 Answers  

---

WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers   Wipro,

---

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 is Audit table?Have u use audit table in ur project?

3 Answers   Accenture, Wipro,

---

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 Answers  

---

Name the different types of Lookups in Datastage?

0 Answers  

---

1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

4 Answers   Syntel,

---

Can you define merge?

0 Answers  

---

it is possible to load two tables data into one sequential file?if possible how?plz share with me?

6 Answers   TCS,

---

Terminate Activity

0 Answers   CTS,

---

What is the difference between SQl Loader and OCI in datastage?

2 Answers   CSC,

---