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
- 6566 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 |
Can you explain kafka connector?
how to find diff between 2 dates without using Icon... funtions?
what is parameterset?
how can we join one oracle & flat files ?
What is the project in datastage?
I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
what is data mapping
SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y
What is the difference between in process and inter process?
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
How do u call shellscript/Batch file from DS?
Teradata 
