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

2 Answers   CSC,

---

What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 Answers  

---

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  

---

where we use column generator stage in real time scenario?

5 Answers   TCS,

---

How do you run datastage job from the command line?

0 Answers  

---

---

Difference in the implementation of lookup and join stages,in joining two tables?

7 Answers   TCS,

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

0 Answers   Cap Gemini, TCS,

---

how can we join one oracle & flat files ?

2 Answers   ME,

---

Difference between server jobs & parallel jobs?

0 Answers  

---

What is the difference between Datastage 7.5 and 7.0?

0 Answers  

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

0 Answers  

---

difference between function and procedure...

1 Answers   IBM,

---