Answer / fahmida

In server jobs three types of Updates are available,
Update Existing Rows Onlly
Update Existing Rows Or Insert New rows
Insert New rows or Update Existing Rows

In Parallel jobs two types of Update actions are available,
Update
Upsert

i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer

2 Answers  

---

What is the difference between datastage and datastage tx?

0 Answers  

---

how many write modes are there in ds

2 Answers   IBM,

---

How to remove blank spaces from data?

3 Answers  

---

on how many columns we can perform aggregation in the aggregator stage?

2 Answers   Reliance,

---

How to convert alpha Numeric values to alpha using functions?

1 Answers   CTS,

---

what is advantages of snowflake when it is used?

3 Answers   IBM,

---

Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.

3 Answers   Cognizant, UHG,

---

Explain the ChangeApply stage?

11 Answers  

---

how to call sequential generator in datastage?

1 Answers   IBM,

---

I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

4 Answers   CSC,

---

i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?

4 Answers   IBM,

---