what is the use of materialized view?

0 Answers   CTS,

---

How many types of sorting methods are available in datastage?

0 Answers  

---

tell me abt Datastage trigger?

1 Answers   HP, IBM,

---

What is the difference between validated and compiled in the datastage?

0 Answers  

---

how to run jon in unix back round process what is command use in runing a job?

2 Answers   HSBC,

---

in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

10 Answers   Wipro,

---

What is Horizontal transformation, vertical transformation,diagonal transformation?

2 Answers   Cap Gemini,

---

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, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers   CGI,

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

0 Answers  

---

What are the prerequisites for join stage

2 Answers  

---

I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,

---