Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 6569 Views
- ABC, I also Faced
- E-Mail Answers
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
How to find value from a column in a dataset?
what are the devoleper roles in real time? plz tell i am new to datastage....
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What is the importance of the exception activity in datastage?
What are the types of views in datastage director?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Why we use surrogate key?
Differentiate between datastage and datastage tx?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
How many types of sorting methods are available in datastage?
What are the types of hashed files in data stage
Demonstrate experience in maintaining quality process standards?
What is use Array size in datastage
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Can you explain players in datastage?
