Answer Posted / satish

Hi

First read the data in sequential file,
then take transformer stage create a stage variable.
In stage variable 

Str( DSLink2.column_2, DSLink2.Column_1).

Drag and drop the stage variable to required output column,
finally load the data in target. 

what are the errors,warnings in datastage

2674

---

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

8758

---

What could be a data source system?

988

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

2429

---

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

919

---

Define Job control?

1118

---

What is data partitioning?

1176

---

in oracle target stage when we use load option and when we use upsert option?

2259

---

How to RD using transformer?

1406

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

785

---

What are the types of hashed files in data stage

1097

---

How a routine is called in datastage job?

1080

---

What is the difference between account and directory options ?

1161

---

How many areas for files does datastage have?

1135

---

What are the various kinds of containers available in datastage?

1017

---