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

Which warehouse using in your datawarehouse

0 Answers   IBM,


how can we create a Sorrogate key in transformer stage? I want it in parallel mode

2 Answers   Syntel,


What is the sortmerge collector?

0 Answers  


what are the errors,warnings in datastage

0 Answers   Syntel, Wipro,


specify data stage strength?

1 Answers  






I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

3 Answers   CTS, IBM,


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

0 Answers  


how to retrive the max(sal),deptno,empno in datastage?

13 Answers   Polaris,


Give an idea of system variables.

0 Answers  


what are fact tables and dimension tables? give example assuming one table.

3 Answers   IBM,


Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers   Accenture,


How to find value from a column in a dataset?

0 Answers   TIAA CREF,


Categories