Answer Posted / vipul

IBM Websphere Datastage has series of ETL tools which
SERVES EXTRACTION , TRANSFORMATION and LOADING needs.

1. IBM DATASTAGE TX is the Any to Any message
Transformation tool. It accepts message of any format (
xml, fixed length ) and can convert it to any desired
format.

2 .IBM DATASTAGE PX is completely different.. checkout on
http://www-306.ibm.com/software/info1/websphere/index.jsp?
tab=products/enterprisetransformation

What are orabulk and bcp stages?

1068

---

what is the use of surogate key in datastage

2249

---

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

2315

---

Difference between sequential file and data set?

1134

---

What is the flow of loading data into fact & dimensional tables?

1012

---

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4137

---

What is job control?

1034

---

How many types of hash files are there?

1117

---

sed,awk,head

1409

---

What are the different layers in the information server architecture?

1076

---

How do you generate sequence number in datastage?

1025

---

How can you write parallel routines in datastage PX?

974

---

Differentiate between datastage and datastage tx?

1003

---

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

752

---

Why do we use link partitioner and link collector in datastage?

1076

---