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
- 6571 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 |
How can we improve performance of data stage jobs?
I have a few records just I want to store data in to targets cycling way how?
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
how to convert rows into columns
What is a ds designer?
What are the partition techniques available in your last project?
What is size of a transaction and an array means in a datastage?
Explain the situation where you have applied SCD in your project?
I have a few records all are same structures data, I want to store data in multiple targets how?
WHAT IS FORCE COMPILE?
CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?
wt is the diff b/w odbc and oracle stage
Teradata 
