i have 3 diffrent tables. 1) US rate data 2)CANADA rate
data and 3)MEXICO rate data. All 3 tables have 6 collumns
each. 4 collumns are commun to all tables and 2 are
diffrent. Now at target i want single table say Country
rate which will have (4+2+2+2+1 flag) 11 collumns. I will
add a flag collumn which will indicate country and will put
nullable collumns which are not common to other. How i can
implement this in datastage?
Answer Posted / ramana
While extracting the US rate data from the table create 4
new columns(in the select query itself), which are the
distinct columns from the other 2 databases and a new
column FLAG set it to the value to indicate the country.
Continue the above process to the other 2 countries. Then
you will get a consolidated meta data for all the 3
countries. Then funnel those 3 streams into one and load it
into the target table.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the features of datastage flow designer?
What are sequencers?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Describe link sort?
What are transforms and what is the differenece between routines and transforms?
Explain ibm infosphere information server and highlight its main features?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
How do you import and export the datastage jobs?
What are the types of containers?
What are system variables and sequencers in datastage
What are the job parameters?
what is ds administrator used for?
Define ds designer?
Describe the architecture of datastage?
What are the some differences between 7.x and 8.x version of datastage?