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

1320

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

1113

What is the difference between the local container and shared container?

1057

What are the types of containers and how to create them?

949

what is use of SDR function?

5141

How can one find bugs in job sequence?

1345

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2943

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?

2188

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

2408

how to abort the job its matain duplicates?

2546

Nls stands for what in datastage?

1155

How you Implemented SCD Type 1 & Type 2 in your project?

4085

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?

2141

whom do you report?

1889

Why do you need stage variables?

1143