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
Nls stands for what in datastage?
What is a delta record? How you will read it?
How to create a doccument in datastage?
Explain briefly scd type2 in datastage7.5x2(parallel)
IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?
How do u set a default value to a column if the column value is NULL?
what is difference between migration project and integration project? can anyone explain with the example Thanks in advance
tell me abt Datastage trigger?
Whats difference betweeen operational data stage (ods) and data warehouse?
AGGREGATOR default datatype
I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..
9 Answers Cognizant, IBM, TCS, Virtusa,
How did you reconcile source with target?