What is the difference between lookup and sparse lookup?

1 Answers  

---

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

3 Answers   Reliance,

---

What is mapping?

3 Answers  

---

How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?

2 Answers  

---

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

1 Answers   Amdocs,

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

0 Answers  

---

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

0 Answers   Wipro,

---

i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want

3 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,

---

Wat is pre-load in Hashed file

1 Answers   Patni,

---

How the ipc stage work?

0 Answers  

---

WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD

8 Answers   L&T,

---