Answer / prasad

i think there is no function on rank , you can write a sql
query for that one in oracle stage or drs stage/

i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?

5 Answers   HSBC,

---

What are routines in datastage? Enlist various types of routines.

0 Answers  

---

What are the differences between datastage and informatica?

0 Answers  

---

What is the difference between orabulk and bcp stages?

0 Answers  

---

Give example for FACTLESS FACT TABLE in real-time scenario.

4 Answers   TCS,

---

Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?

7 Answers   IBM,

---

1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

---

A flat file 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 this job?

1 Answers   TCS,

---

What are the some differences between 7.x and 8.x version of datastage?

0 Answers  

---

In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?

2 Answers   Polaris,

---

i have the source from Uk,north america how can i pass the data two tables based on the locations

2 Answers  

---

How many areas for files does datastage have?

0 Answers  

---