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.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Stage Interview Questions

Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 Answers  


What is container and then types?

1 Answers  


What is active and passive stage?

0 Answers  


Explain usage analysis in datastage?

0 Answers  


how can we join one oracle & flat files ?

2 Answers   ME,


Which commands are used to import and export the datastage jobs?

0 Answers  


in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

10 Answers   Wipro,


Difference between sequential file and data set?

0 Answers  


What is process model?

0 Answers  


what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????

1 Answers   TCS,


how can find maximum salary by using Remove duplicate stage?

5 Answers   IBM,


What are the types of containers in datastage?

0 Answers  


Categories