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  

---

What are the functionalities of link partitioner and link collector?

0 Answers  

---

i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage

6 Answers  

---

What are the different database update actions available?

1 Answers   HP,

---

what is parameterset?

4 Answers   Wipro,

---

Is the value of staging variable stored temporarily or permanently?

0 Answers  

---

How a routine is called in datastage job?

0 Answers  

---

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

0 Answers  

---

What is a merge in datastage?

0 Answers  

---

what is data mapping

2 Answers  

---

where we use column generator stage in real time scenario?

5 Answers   TCS,

---

what are the devoleper roles in real time? plz tell i am new to datastage....

0 Answers   Mphasis,

---