Answer Posted / deepanshu

supposing single column is there having values
278
951
736

sol'n :
Use transformer string function with @inrownum variable.

inputcolumn[@inrownum,1]
will give you desired o/p

What is difference between join, merge and lookup stage?

1100

---

What is a merge?

1171

---

how to implement scd2 in datastage 7.5 with lookup stage

5607

---

What is meta stage?

1185

---

how can we create rank using datastage?what is the meaning of rank?

8795

---

What are the job parameters?

1221

---

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2230

---

How many types of sorting methods are available in datastage?

1075

---

Describe the main features of datastage?

1076

---

How many types of hash files are there?

1185

---

What is orabulk stage?

1047

---

How to read multiple files using a single datastage job if files have the same metadata?

1252

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2295

---

Differentiate between validated and Compiled in the Datastage?

1284

---

What is the command line function to import and export the ds jobs?

1153

---