| Other Data Stage Interview Questions |
|| Asked @
i want to get o/p as
how it can be done on using datastage?
|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
|How to create user defined environment varibale(parameter)?
|how do you pass parameters in a script?
|is it possible to access the same job by two users at a time
|Explain the functionality of your current project?
|How u implement the slowly changing dimensions if my source
table is consisting of cid,cname,add,phno,email but i need to
capture the changes for first three columns how u implement?
|i have 3 diffrent tables. 1) US rate data 2)CANADA rate
data and 3)MEXICO rate data. All 3 tables have 6 collumns
each. 4 collumns are commun to all tables and 2 are
diffrent. Now at target i want single table say Country
rate which will have (4+2+2+2+1 flag) 11 collumns. I will
add a flag collumn which will indicate country and will put
nullable collumns which are not common to other. How i can
implement this in datastage?
|parallel jobs run on cluster machines.
server jobs run on smp and mpp.
What do mean by cluster mechines and SMP and MPP..?
|Explain briefly scd type2 in datastage7.5x2(parallel)
|How To find the location of APT_confid file
|I have scenario like this seq file --> transformer --> sort
stage --> dataset
In this job which prtitioning technique you are using and
|For more Data Stage Interview Questions Click Here |