Answer Posted / pranay

seq file ------> Transformer -------> target

1.extract the source data into seq file.
2.In transformer source column to target , and apply the field function
Field(column name, ',' , 1)
next same drag the source column to target , and apply the field function
Field(column name,',',2)
.
.
.
Field(column name,',',5)

How many areas for files does datastage have?

1085

---

What is data partitioning?

1138

---

What is the difference between Datastage 7.5 and 7.0?

1050

---

What is the difference between server job and parallel jobs?

1094

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3132

---

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1687

---

what is the custome stage in datastage? how can we impliment that one? plz tell me

2317

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2676

---

Can you explain repository tables in datastage?

1342

---

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2661

---

To see hidden files in LINIX?

1454

---

CHANGE CAPTURE

1258

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2130

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2007

---

what is the use of surogate key in datastage

2251

---