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
- 6487 Views
- ABC, I also Faced
- E-Mail Answers
Answer / 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 |
What is use Array size in datastage
how to handle null values using transformer stage?
What are the processing stages?
Wat is isolation level and when do u use them?
What is the differentiate between data file and descriptor file?
what is a force compile
where we use column generator stage in real time scenario?
plz tell me some dimentional and fact table names in banking project?
insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?
How did you reconcile source with target?
If the job aborted in a sequencer, how can we start that from the previews successful job.
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Teradata 
