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
- 9362 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
How the ipc stage work?
which r the connectors used in san?
What is the purpose of interprocessor stage in server jobs?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Explain the datastage parallel extender (px) or enterprise edition (ee)?
what are the devoleper roles in real time? plz tell i am new to datastage....
What is the roundrobin collector?
What is the method of removing duplicates, without the remove duplicate stage?
How do y read Sequential file from job control?
Define repository tables in datastage?
What is the use of datastage designer?
What are stage variables and constants?
What are routines in datastage?
Explain entity, attribute and relationship in datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
