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
- 10565 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 delete one row in target dataset
What is process model?
what is operator combinality in datastage?
What are the various kinds of containers available in datastage?
Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?
15 Answers Scope International,
Terminate Activity
why we use parameters instead of hard code in datastage
Explain briefly scd type2 in datastage7.5x2(parallel)
how can we create a Sorrogate key in transformer stage? I want it in parallel mode
What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
Name the different types of Lookups in Datastage?
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
Teradata 
