Answer / suby

I completed Datastage certification with the pdf dumps and test codes conducted by IBM are below:

000-418 : IBM Websphere Datastage V.8.0
000-421 : IBM Websphere Datastage V.8.5

If you need dumps, email me at suby.ibm@gmail.com

Thanks
Suby

Answer / pranalika

Now the NEW DataStage certification codes are the below

C2090-303 : IBM InfoSphere DataStage v9.1
C2090-421 : InfoSphere DataStage v8.5

I got from this link : http://bit.ly/Sy4o9I and passed with good % score

How can you find out whether datastage process is running or not in unix?

3 Answers   Accenture,

---

how to define satge variables in transformer stage

2 Answers  

---

there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers   Virtusa,

---

Tell me the syntax of Configuration file?

1 Answers  

---

Name the different sorting methods in datastage.

0 Answers  

---

what is initial load and incremental load

3 Answers   ADP,

---

1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

---

What is the default execution order of the sequential file?

3 Answers  

---

Define Routines and their types?

0 Answers  

---

how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?

3 Answers   Accenture,

---

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  

---

Why we need datasets ratherthan sequential files?

5 Answers  

---