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
- 10917 Views
- UHG, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sriharsha vemuri
Take source as emp_no,qualification 1,b 2,b 2,c 3,a and
reference as date as emp_no,qualification 1,a 1,b 1,c 2,a
2,b 2,c3,a3,c 3,b now take lookup for both
emp_no,qualification columns and reject the date. This Worked.
| Is This Answer Correct ? | 12 Yes | 2 No |
Since Each Employee should have 3 qualification then Primary
file should be like below because Primary is always Static.
In which terms it should be like this.
Primary file:
empno,qua
1,a
1,b
1,c
2,a
2,b
2,c
3,a
3,b
3,c
And this is our Reference data we have.
RefFile:
empno,qua
1,a
1,c
2,a
3,c
3,b
Primary,ref-->lookup-->output & Reject.
and match the empno and qua and set lookup failue = reject
at reject file
U will get desired output.
Thats it.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / sher
A) Read distinct emp_no we get 1,2,3 add a new column and populate as 1
B) read qualification, we get a,b,c add add a new column and populate as 1
Inner join A and B on new column…
we get 1-A,1-B,1-C 2-A,2-B,2-C and 3-A,3-B,3-C
Change capture with input file and drop all records with no change.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
how to closeing records after 10,000 records come?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Can you highlight the main features of ibm infosphere information server?
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
how to do pergformence tuning in datastage?
can we half project in parallel jobs and half project in server jobs?
I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???
Enlist various types of routines in datastage.
Where do you see different stages in the designer?
how to validate the jobs
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.
Teradata 
