Since Each Employee should have 3 qualification then Primary file should b

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.

Question Posted / shar

4 Answers
10765 Views
UHG, I also Faced
E-Mail Answers

Answer Posted / shar

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the enhancements made in datastage 7.5 compare with 7.0?

1150

what is the difference between == and eq in UNIX shell scripting?

1502

What are the types of containers?

1239

What are the different plug-ins stages used in your projects?

1078

Can you explain engine tier in information server?

1137

Differentiate between validated and Compiled in the Datastage?

1288

create a job that splits the data in the Jobs.txt file into four output files. You will direct the data to the different output files using constraints. • Job name: JobLevels • Source file: Jobs.txt • Target file 1: LowLevelJobs.txt − min_lvl between 0 and 25 inclusive. − Same column types and headings as Jobs.txt. − Include column names in the first line of the output file. − Job description column should be preceded by the string “Job Title:” and embedded within square brackets. For example, if the job description is “Designer”, the derived value is: “Job Title: [Designer]”. • Target file 2: MidLevelJobs.txt − min_lvl between 26 and 100 inclusive. − Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt − min_lvl between 101 and 500 inclusive. − Same format and derivations as Target file 1. • Rejects file: JobRejects.txt − min_lvl is out of range, i.e., below 0 or above 500. − This file has only two columns: job_id and reject_desc. − reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: ”, where is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.

2725

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

810

What are the functionalities of link partitioner and link collector?

1011

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1555

what is flow of project?

2002

What are the functionalities of link collector?

1085

How to reverse the string using unix?

3515

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1008

Give an idea of system variables.

1038