1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4098

What are the main features of datastage?

1352

What is the use of hoursfromtime() function in transformer stage in datastage?

1114

Define oconv () and iconv () functions in datastage?

1467

Define data aggregation?

1148

What is a datastage job?

1055

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2263

What is the different type of jobs in datastage?

1030

How to clean the datastage repository?

1180

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2074

How rejected rows are managed in datastage?

1574

How to implement complex jobs in data stage?

1159

What are datastage sequences?

1168

Explain connectivity between datastage with datasources?

1040

What is the differentiate between data file and descriptor file?

1412