| Other Data Stage Interview Questions |
|| Asked @
i have one scenario like if
source--->transformer-->2 target sequential files
the 1 st target sequential file is loads the data from
and 2nd target sequntial file contain the 1st target total
record count,and file name of 1 st target seq file and
timestamp seperated by delimeter
for example if source have 10 record the 1st target seq
file hav 10 records
2nd target seq file example
could you please help me out how can i implement in
|what is meta data? Explain? Where it is used?
|what r the stages mostly used in realtime scenarios
|what are the different type of errors in datastage?
|I have a input as:
I want 3 output as:
i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help
output should be in three targets
T1 T2 T3
1 3 5
2 4 6
how to do this? can any one help?
|I have a scenario like
Deptno=10---->First record and last record
Deptno=20---->First record and last record
Deptno=30---->First record and last record
I want those first and last records from each department in
a single target. How to do this in DataStage, any one can
Thanks in advance.
|1)What is ur project architecture ?
2)how to move project from developement to uat?
3)What is the difference between datastage 6,7.1 and
4).How to do error handling in datastage?
5)3.Whta is unit testing, system testing and integration
6)What is the Exact difference between BASIC Transformer
and NORMAL Transformer?When we will go for BASIC Or NORMAL
7)why we use third party tools in datastage?
8)What is the purpose of Debugging stages? In real time
Where we will use?
|at source level i have 40 columns,i want only 20 cols at
target what r the various ways to get it
perfoms outerjoin what is the o/p?
write sql query for outerjoin?
|how to do pergformence tuning in datastage?
|What is the default padding character?
|For more Data Stage Interview Questions Click Here |