Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 8298 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the functionalities of link collector?
In Datastage, how you can fix the truncated data error?
What is the difference between datastage and informatica?
What is the difference between passive stage and active stage?
Define project in datastage?
What is difference between server jobs & parallel jobs?
How to find value from a column in a dataset?
What are stage variables?
Define orabulk and bcp stages?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Why fact table is in normal form?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What are the functionalities of link partitioner?
whom do you report?
If you want to use the same piece of code in different jobs, how will you achieve it?
