Answer / lakshmi

Working up with fact jobs is a complex one as to gather the source from multiple dimensions in to one dataset, while gathering it may endup with joining many lookups and db connectors.

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

0 Answers   Reliance,

---

Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

3 Answers   TCS,

---

What is RCP

5 Answers   CGI, CTS,

---

i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 Answers   TCS,

---

Why we use parameters instead of hard code in datastage.

2 Answers   IBM,

---

Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S

3 Answers  

---

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

8 Answers   Cognizant, HCL, TIAA CREF,

---

Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?

2 Answers  

---

How to reverse the string using SQL?

0 Answers   CTS,

---

What are the types of views in datastage director?

0 Answers  

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

0 Answers  

---

what is the diff between sequential file and fileset stages?

3 Answers  

---