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
- 6480 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 can we improve the performance in datastage?
describe the Steps to confiure a Qlogic switch
Why fact table is in normal form?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Differentiate between validated and Compiled in the Datastage?
What is the difference between passive stage and active stage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Difference between data warehousing and olap?
What is merge stage?
what are the errors,warnings in datastage
What is a ds designer?
what is the custome stage in datastage? how can we impliment that one? plz tell me
client know skid info?
What is a quality stage in datastage tool?
Define Job control?
