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

what is initial load and incremental load

3 Answers   ADP,

---

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)

0 Answers  

---

Distinguish between informatica & datastage. Which one would you choose and why?

0 Answers  

---

tell me abt Datastage trigger?

1 Answers   HP, IBM,

---

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

2 Answers   MGL,

---

What is meta stage?

0 Answers  

---

Can you implement SCD2 using join, transformer and funnel stage?

0 Answers   Cognizant,

---

What is the difference between validate and compile?

1 Answers   CTS,

---

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

0 Answers  

---

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  

---

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,

---

How many jobs in ur project? Explain any complex job u have done in ur project?

1 Answers   IBM, TCS,

---