Answer Posted / venkata ramana

Input:Seq file
empid,salary
10,1000
20,2000
30,3000
40,4000

Sequential file stage--->Trasformar Stage---->Dataset Stage

Transformation Logic:

InputTab-->Partition--> select "same"---> Select "Perform Sort" on key "empid"

Declaration of Stage Variables:

PrevSal Varchar ( Set right Intial value ' ' i.e Null value)
CurSal Varchar

Derivation Stage Variables
---------- ---------------
CurSal PrevSal
Linkname.Salary CurSal

Derivation Column name
--------- -----------
Linkname.empid empid
Linkname.Salary Salary
PrevSal previoussalary

Output DataSet result:-
empid salary previoussalary
10 1000 null
20 2000 1000
30 3000 2000
40 4000 3000

What is oci?

1352

---

What are some prerequisites for datastage?

1168

---

how to export or import the jobs in .ISX file

1250

---

Define repository tables in datastage?

1202

---

What is a folder? Difference types of stages?

1240

---

Differentiate between operational datastage (ods) and data warehouse?

1231

---

Define Data Stage?

1140

---

What are routines in datastage?

1379

---

What is the use of datastage designer?

1218

---

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 ?

2074

---

Does datastage support slowly changing dimensions ?

1156

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

3018

---

Can you explain link buffering?

1221

---

How do you import and export data into datastage?

1294

---

What are the various kinds of containers available in datastage?

1100

---