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

cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle

3 Answers   TCS,

---

what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,

---

What is the process of killing a job in datastage?

0 Answers  

---

How you can fix the truncated data error in datastage?

0 Answers  

---

1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?

7 Answers   Wipro,

---

HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com

5 Answers   FIS,

---

difference between function and procedure...

1 Answers   IBM,

---

What are the partitioning techniques available in link partitioner?

0 Answers  

---

I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,

---

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers  

---

how to find diff between 2 dates without using Icon... funtions?

1 Answers  

---

Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.

1 Answers   IBM,

---