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.
What are stage variables and constants?
What are the repository tables in datastage?
How many areas for files does datastage have?
What are the various kinds of the hash file?
Differentiate between Join, Merge and Lookup stage?
Can you explain tagbatch restructure operator?
What are the different kinds of views available in a datastage director?
what are the devoleper roles in real time? plz tell i am new to datastage....
What is the importance of the exception activity in datastage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is the sortmerge collector?
What is container and then types?