Interested to Buy Any Domain ? << Click Here >> for more details...
Hi guys,
Please design a job for dis requirement with
derivation(solution).
my source table like dis.
emp_no qualification
1 a
1 c
2 a
3 c
3 b
To loaded to target like dis
emp_no qualification
1 b
2 b
2 c
3 a
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
Thanks.
- 0 Answers
- 2836 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
what is the differeces between hash and modulus partition methods
Differentiate between Join, Merge and Lookup stage?
when u face critical situation in ur project, how to solve them?
Is it possible to query a hash file?
how to add a new records into source?
How to get max salary of an organization using data stage stages........... can any body help me plz.......
What are the different types of lookups in datastage?
what are the errors,warnings in datastage
Explain the scenarios where sequential file stage runs in parallel?
How rejected rows are managed in datastage?
Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
Teradata 
