I have a source table with column name CITY having 100
I want target table with column name start with 'A'
and 'B',remaining columns as reject outputs.
how can achieve this by data stage?please help me?????
I have a input data like,
And i want my output data like
class_id Marks Rank
101 50 2
101 60 1
101 40 3
102 90 1
102 35 2
how to do this in datastage?
please design a job with derivation(solution).
write exact conditions.
Here every employer have three qualifications i.e a,b and c.
what ever source table dont have some qualification, that
will be move to target table.
Hope u get the point.
Please design a job for dis requirement with
my source table like dis.
To loaded to target like dis
my requirement is
every employer have three qualifications i.e a,b and c.
what qualification missed in source table that will be move
to target systems.
Hope u got it the requirement. Right
1)what is the size of Fact table and dimension table?
2)how to find the size of Fact table and dimension table?
3)how to implement the surrogate key in transform stage?
4)write the configuration file path?
5)how many types of datasets explain?
6)diff b/w developed projects and migration projects?
7)how to delete the header and footer file of the sequencer
8)how can u call the parameters in DS in unix environment?
9) how much data ur getting daily ?
What is developer responsibilities in UAT
(user acceptance testing and
Post implementation phase?
My source is oracle(eno,ename,sal,commision,...), my
requirement is like this,
if there is a null values in commission col i want to keep
it as null,and for the remaining first two characters of
the value in my target.
Plz help me
How can we perform 2nd time extraction of client database
without accepting the data which is already loaded in first