Answer Posted / amit

Two tables means, there is a possibility of mismatching metadata. In this case also, we can load data into a sequential file without maintaining the metadata of two tables.

If we want to keep track of these records, then we can, add one record identifier field, to later identify the records while extracting data from file.

How do you run datastage job from the command line?

1093

---

what is the use of skid in reporting?

2381

---

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?

2179

---

How do you register plug-ins?

962

---

Explain how a source file is populated?

1366

---

why do u need the IOS upgradation in a FC switch

2283

---

Describe the main features of datastage?

1076

---

Differentiate between odbc and drs stage?

1050

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1382

---

If you want to use a same piece of code in different jobs, how will you achieve this?

1276

---

What are stage variables?

1203

---

If you want to use the same piece of code in different jobs, how will you achieve it?

1158

---

What steps should be taken to improve Datastage jobs?

1073

---

How many Key we can define in remove duplicate stage?

1388

---

What are the enhancements made in datastage 7.5 compare with 7.0?

1149

---