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

My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.

6 Answers   Wipro,

---

How do you generate sequence number in datastage?

0 Answers  

---

How can remove duplicates in a file using UNIX?

3 Answers   Cap Gemini,

---

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

6 Answers   IBM,

---

how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction

1 Answers   Reliance,

---

count number of deptno in a emp table?

2 Answers   IBM,

---

where the log files or tables can store in DS?

2 Answers   IBM,

---

Thanks to all people who are posting their comments...

1 Answers   CTS,

---

i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers   ABC,

---

what is the difference between datasatge and datastage TX?

6 Answers  

---

i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?

8 Answers   IBM,

---

What are the various kinds of the hash file?

0 Answers  

---