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
- 6381 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 add a new records into source?
On which interface you will be working as a developer?
Define Job control?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is the difference between an operational datastage and a data warehouse?
What is the method of removing duplicates, without the remove duplicate stage?
What are the repository tables in datastage?
What is the difference between the local container and shared container?
How to RD using transformer?
What are some prerequisites for datastage?
Differentiate between datastage and datastage tx?
If you want to use the same piece of code in different jobs, how will you achieve it?
What are the job parameters?
what is ds administrator used for?
What is a folder? Difference types of stages?
