What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
Post New Answer View All Answers
On which Dimension Table you implemented SCD Type in your Project
How many types of hash files are there?
what is use of SDR function?
How do you run datastage job from the command line?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
How to Remove Duplicate using SQL?
Difference between in process and inter process?
what is ds administrator used for?
Can you explain players in datastage?
What are some different alternative commands associated with "dsjob"?
whom do you report?
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.
options available in sequence job to run,validate?
Nls stands for what in datastage?
What is the roundrobin collector?