table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?
Answer Posted / akhi
It is Simple in join stage fullouterjoin technique we get
all 10 coloumns
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
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.
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
what is flow of project?
what is the use of surogate key in datastage
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What are the areas of application?
What are the primary usages of datastage tool?
Enlist various types of routines in datastage.
How to RD using transformer?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What is process model?
How complex jobs are implemented in datstage to improve performance?
Why do you need stage variables?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is a datastage job?