WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

0 Answers  

---

input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?

2 Answers   HSBC,

---

souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 Answers  

---

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls

7 Answers   TCS,

---

what is the use of materialized view?

0 Answers   CTS,

---

Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.

1 Answers   IBM,

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

0 Answers   IBM,

---

Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

1 Answers   HCL,

---

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  

---

What is the difference between datastage and informatica?

0 Answers  

---

How can we select pr retrieve the particular row in dataset by using orchadmin command?

1 Answers   IBM,

---

What are the partitioning techniques available in link partitioner?

0 Answers  

---