Answer / sudhir kanojia

There are five types of write modes:-

1.Append
2.Overwrite
3.Create(Error if exist)
4.Use existing (discard record)
5.Use existing (discard record & schema)

Posted By:-
Sudhir Kanojia

Answer / saidarao

APPEND
CREATE
TRUNCATE
REPLACE
ONLY 4 WRITE MODES IN DATASTAGE

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 is executable in DataStage?

2 Answers  

---

How we can covert server job to a parallel job?

0 Answers  

---

what is ds administrator used for?

0 Answers  

---

1.what is materialized data? 2.how to view the materialized data?

0 Answers   HCL, IBM,

---

what is initial load and incremental load

3 Answers   ADP,

---

Can you explain kafka connector?

0 Answers  

---

I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage

3 Answers   IBM,

---

what r the sources u need to create the datastage?

1 Answers  

---

Difference between sequential file and data set?

0 Answers  

---

can a fact table contains textual information

6 Answers   HCL, HCL BSERV, IBM,

---

source file contains 100 records, i want 10 records in target file how it possible in datastage

6 Answers   IBM,

---