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
- 10745 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
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Enlist various types of routines in datastage.
How we can covert server job to a parallel job?
what are the devoleper roles in real time? plz tell i am new to datastage....
What are stage variables, derivations and constants?
Define orabulk and bcp stages?
What is the process of killing a job in datastage?
whom do you report?
If you want to use a same piece of code in different jobs, how will you achieve this?
What are the components of datastage?
how to export or import the jobs in .ISX file
What is the method of removing duplicates, without the remove duplicate stage?
What is ibm datastage flow designer?
What is the difference between datastage and datastage tx?
Define oconv () and iconv () functions in datastage?
