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
- 3505 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..
what is the difference between datasatge and datastage TX?
What is RCP
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD
In which situations we can use normal and sparse lookup stages
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
What is the use of datastage designer?
How to RD using transformer?
how can you generate sequence number using only the sequential file stage?
How to perform incremental load in datastage?
What is quality stage?
Name the different sorting methods in datastage.
Teradata 
