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
- 9659 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 |
Pls tell me what is troubleshooting in datastage view?
I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().
What is oci?
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
What is ibm datastage?
What is the purpose of interprocessor stage in server jobs?
What is merge stage?
how to cleansing data
what is the best stage in datastage parller jobs to use full out join and why
1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...
How do u view log file for a particular job?
how to design the change capture stage in(data stage parallel jobs) type 2
Teradata 
