Interested to Buy Any Domain ? << Click Here >> for more details...
Hi guys,
please design a job with derivation(solution).
write exact conditions.
My requirement
Source table
emp_no qualification
1 a
1 c
2 a
3 c
3 b
Target table
emp_no qualification
1 b
2 b
2 c
3 a
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.
Like above.
Hope u get the point.
Thanks.
- 4 Answers
- 10568 Views
- UHG, I also Faced
- E-Mail Answers
Answer Posted / suneelbabu.etl
Here as my knowledge
Seq--->Tx---->DS
In Tx by using stage varible we can do dis.
Thanks.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What is usage analysis in datastage?
What are stage variables and constants?
How to Remove Duplicate using SQL?
Can you explain repository tables in datastage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
How to implement complex jobs in data stage?
What is the difference between Datastage 7.5 and 7.0?
How do u convert the columns to rows in datastage?
What is the difference between server job and parallel jobs?
What is the use of datastage director?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What is difference between join, merge and lookup stage?
Have you have ever worked in unix environment and why it is useful in datastage?
what is ds administrator used for?
AGGREGATOR default datatype
