Answer Posted / vijay

create a one dummy column in both tables .

like dummy x in t1 table,
dummy x in t2 table.

make a inner join .. then u ll get data from both tables.

What is the different type of jobs in datastage?

962

---

How a server job can be converted to a parallel job?

1090

---

Differentiate between operational datastage (ods) and data warehouse?

1172

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2225

---

EXPLAIN SCD

1389

---

Highlight the main features of datastage?

1155

---

What is the difference between odbc and drs stage?

1087

---

What are the various kinds of containers available in datastage?

1044

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2170

---

In Datastage, how you can fix the truncated data error?

1150

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1406

---

Name the third party tools that can be used in datastage?

1073

---

What is oci?

1297

---

What is the project in datastage?

1105

---

Differentiate between datastage and informatica?

1178

---