Answer Posted / ashok

TRANSFORMER:
------------
STEP1:
Take 3 stage variables
NAME--->s1
if s1<>s3 then LOC else s2:LOC --->s2
s1--->s3
STEP2:
In derivations s2--->LOC Field
Remove duplicate stage:
-----------------------
Retaining last

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2102

---

What are the types of jobs we have in datastage?

1071

---

What is the difference between operational data stage (ods) and data warehouse?

1239

---

What are the different kinds of views available in a datastage director?

1027

---

What is the difference between odbc and drs stage?

1091

---

Define Routines and their types?

1182

---

Can you highlight the main features of ibm infosphere information server?

1088

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

918

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2081

---

How do you remove duplicate values in datastage?

1151

---

CHANGE CAPTURE

1298

---

How do you start developing a datastage project?

1103

---

What is the difference between server job and parallel jobs?

1152

---

What are orabulk and bcp stages?

1120

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2185

---