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
- 3513 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Give an idea of system variables.
how can we join one oracle & flat files ?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
what is the definitions for Datawarehose and Datamart?
what is the difference between datasatge and datastage TX?
SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?
What is job control?
What is the flow of loading data into fact & dimensional tables?
What are stage variables and constants?
Explain the functionality of your current project?
1 Answers IBM, Miles Software,
How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?
I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
Teradata 
