Interested to Buy Any Domain ? << Click Here >> for more details...
table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?
- 9 Answers
- 15188 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinivas
u can generate surrogate key generator for both the tables
and u can use Inner join based on key column i.e surrogate
key and u can get 10 columns..
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Where do the datastage jobs get stored?
What is the use of datastage director?
What are the enhancements made in datastage 7.5 compare with 7.0?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What are the stages in datastage?
What are the important features of datastage?
How to clean the datastage repository?
What is the project in datastage?
explain about citrix scheduling tool in datastage
Describe the architecture of datastage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is a datastage job?
how to add a new records into source?
How to reverse the string using unix?
