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
What are the stages in datastage?
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
Differentiate between validated and Compiled in the Datastage?
what is usage of datastage with materialized views
Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?
Differentiate between operational datastage (ods) and data warehouse?
Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari
Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain
What are the prerequisites for join stage
How to find value from a column in a dataset?
what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?