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
- 2880 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment
IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?
why we use parameters instead of hard code in datastage
CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?
what is the use of skid in reporting?
Can we use Round Robin for aggregator?is there any benefit underlying?
what is the best stage in datastage parller jobs to use full out join and why
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
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().
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
Teradata 
