Interested to Buy Any Domain ? << Click Here >> for more details...
Hi guys,
Please design a job for dis requirement with
derivation(solution).
my source table like dis.
emp_no qualification
1 a
1 c
2 a
3 c
3 b
To loaded to target like dis
emp_no qualification
1 b
2 b
2 c
3 a
my requirement is
every employer have three qualifications i.e a,b and c.
what qualification missed in source table that will be move
to target systems.
Hope u got it the requirement. Right
Thanks.
- 0 Answers
- 2955 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y
How we can covert server job to a parallel job?
Define meta stage?
Difference between JOIN,LOOKUP,MERGE?
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
What are the different kinds of views available in a datastage director?
what is data mapping
my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?
Differentiate between datastage and datastage tx?
What is container and then types?
How do you schedule or monitoring the job?
how to sort two columns in single job in datastage.
Teradata 
