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
Give an idea of system variables.
How do y read Sequential file from job control?
whom do you report?
What is ds designer?
What is a folder? Difference types of stages?
Name the third party tools that can be used in datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
How do you start developing a datastage project?
On which Dimension Table you implemented SCD Type in your Project
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the important features of datastage?
options available in sequence job to run,validate?
Terminate Activity
What is the difference between validated and compiled in the datastage?
What are the different layers in the information server architecture?