Can you implement SCD2 using join, transformer and funnel stage?

1549

What are the different common services in datastage?

1276

in oracle target stage when we use load option and when we use upsert option?

2277

How and where you used hash file?

1168

What are the differences between datastage and informatica?

1170

What is the difference between an operational datastage and a data warehouse?

1152

What are the components of datastage?

1121

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 ?

2017

Which algorithm you used for your hashfile?

1175

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2892

Explain the importance of surrogate key in data warehousing?

1185

what is the use of materialized view?

1561

Describe stream connector?

1305

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2248

What is apt_config in datastage?

1131