How can we select pr retrieve the particular row in dataset by using orchadmin command?

1 Answers   IBM,

---

how to find no.of records in sequntial file itself?

4 Answers  

---

how to handle null values using transformer stage?

1 Answers  

---

What is the process of killing a job in datastage?

0 Answers  

---

Which type of joins Merge stage can support?

7 Answers   IBM,

---

---

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  

---

Differentiate between data file and descriptor file?

0 Answers  

---

explain unit testing,systemtesting,integrated testing

1 Answers   CSC,

---

what is the difference between 7.1,7.5.2,8.1 versions in datastage?

3 Answers   IBM,

---

Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del

3 Answers   HCL,

---

Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.

1 Answers  

---

how to delete one row in target dataset

0 Answers   Satyam,

---