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

Describe link sort?

642

---

What are the steps required to kill the job in Datastage?

682

---

Can you define merge?

666

---

What are the job parameters?

704

---

Explain ibm infosphere information server and highlight its main features?

606

---

---

What is size of a transaction and an array means in a datastage?

737

---

How many areas for files does datastage have?

640

---

Can you implement SCD2 using join, transformer and funnel stage?

1082

---

Is it possible to query a hash file?

1561

---

What are the different layers in the information server architecture?

641

---

I have a few records just I want to store data in to targets cycling way how?

1896

---

What is datastage engine?

730

---

Can you explain players in datastage?

703

---

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2027

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

534

---