there are two schemas x and y are there. some data is in x
schema. i want to use that in y schema..how can i use?
please give some possibilities
Answers were Sorted based on User's Feedback
Answer / brajesh kumar
In most of the cases we dont have the required data in one
schema and it should nt be if its not of same level of
importance. comming to ur question,we can 2 cases:
1. if both schema are present in same database instance.
2. if both schemas are on different database instance.
for 1. we can access data from any schema via sql query
within dtabase connection stage on datastage. the sql
structure wud be according to the required output.
for 2nd one. we need to use 2 database stage and then via
join or other database filter stages u can get ur desired
output.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / nish
since you know the schema already use the modify stage and also make sure that RCP is enabled.
This will help you ensure you get the columns you need.
| Is This Answer Correct ? | 0 Yes | 2 No |
Can you define merge?
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
how to handle null values in sequential file?
souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2
IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?
If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?
I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?
Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del
on how many columns we can perform aggregation in the aggregator stage?
Explain usage analysis in datastage?
2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?
What are the areas of application?