explain how to create SCD-2 IN DATASTAGE 7.5X2
PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE
AND JOB DESINGN URGENT
Answer Posted / harikiran
we can implement scd-2 in ds 7.5.2 server jobs by using
hash file and transformer stage. here hash file can act as
a lookup table.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How we can covert server job to a parallel job?
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.
On which interface you will be working as a developer?
Explain entity, attribute and relationship in datastage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Difference between in process and inter process?
What is the roundrobin collector?
What is the method of removing duplicates, without the remove duplicate stage?
What are some prerequisites for datastage?
Name the different types of Lookups in Datastage?
Differentiate between hash file and sequential file?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
What is the importance of the exception activity in datastage?