Answer Posted / akila

In case an explicit sort stage is used like inteh reply
above, the sort will be done on emp_id(key field) and the
salary. But remove duplicate will be done only on emp_id. I
guess that this might result in a warning like 'sort and
remove duplicates keys do not match'.

How to Remove Duplicate using SQL?

1289

---

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

1028

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1962

---

Explain the importance of surrogate key in data warehousing?

1126

---

What are the functionalities of link partitioner and link collector?

947

---

table actions available in oracle connector?

1553

---

What are datastage sequences?

1056

---

What is the use of hoursfromtime() function in transformer stage in datastage?

999

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2676

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3604

---

What is a folder? Difference types of stages?

1102

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

746

---

Where do you see different stages in the designer?

1034

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2175

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2040

---