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

How can u write exception handling in seq file????

2 Answers   IBM,

---

Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

4 Answers   IBM, PR3 Systems,

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

0 Answers  

---

what is mapping lookup

1 Answers  

---

How to move data set from one server to other?what are the steps to follow to do this?

2 Answers  

---

---

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.

6 Answers   Teradata,

---

i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?

4 Answers  

---

i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com

2 Answers   Wipro,

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,

---

what is the use of DSattchJob?DetachJob? where can we find it?

0 Answers   IBM,

---

What are the unit test cases you used in your project?

1 Answers   CSC, HY,

---

How can we select pr retrieve the particular row in dataset by using orchadmin command?

1 Answers   IBM,

---