How can we perform the 2nd time extraction of client
database without accepting the data which is already loaded
in first time extraction?
No Answer is Posted For this Question
Be the First to Post Answer
Why we use surrogate key?
what is combinability and non combinability?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb
Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
In merge stage can we update the values?
What all the types of jobs you developed?
how do u reduce warnings
Highlight the main features of datastage?
Wat is isolation level and when do u use them?
how do you pass parameters in a script?