Answer Posted / rams

Using pivot stage


ex:-


name,ph1,ph2
ramu,9849,9948
raja,9987,9967
touch,9898,0909


in pivoi stage go to output>- columns


columnname derivation

name
phone PH1,PH2

TO GOT THE RESULT IS


o/p:-

name phone
ramu,9849
ramu 9948
raja,9987
raja,9967
touch,9898
touch,0909

How you Implemented SCD Type 1 & Type 2 in your project?

4179

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3853

---

Is it possible to query a hash file?

2062

---

What is the difference between datastage and informatica?

1185

---

options available in sequence job to run,validate?

1363

---

What is the use of hoursfromtime() function in transformer stage in datastage?

1117

---

Why do we use exception activity in Datastage?

1372

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2329

---

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?

2281

---

How do you run datastage job from the command line?

1132

---

What are the types of containers in datastage?

1226

---

Have you have ever worked in unix environment and why it is useful in datastage?

1189

---

Define meta stage?

1261

---

Can you explain kafka connector?

1380

---

What are the different options associated with dsjob command?

1485

---