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)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 the different type of errors in datastage?