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.
- 0 Answers
- 3609 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?
What is difference between symmetric multiprocessing and massive parallel processing?
HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
how many types of remove the duplicate records?
Differentiate between datastage and datastage tx?
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know
how to load meta data
How to lode data in sequntional files perform faster?
souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2
What are the enhancements made in datastage 7.5 compare with 7.0?
What are some prerequisites for datastage?
Teradata 
