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

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 is job control?

0 Answers  

---

I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().

1 Answers   Amdocs, TCS,

---

wt is the difference between swith and filter stage

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?

0 Answers   Reliance,

---

source file is having 5 records while moving into target it want to be 10 records

4 Answers   IBM,

---

what about data stage requirement

1 Answers  

---

What is the purpose of interprocessor stage in server jobs?

0 Answers   ASD Lab,

---

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 Answers  

---

Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.

7 Answers  

---

Explain usage analysis in datastage?

0 Answers  

---

How we can convert rows to columns in datastage?

4 Answers   IBM,

---