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
- 8205 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
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What is data partitioning?
Could anyone give brief explanation bout datastage admin
What are routines in datastage? Enlist various types of routines.
what is use of SDR function?
How to manage date conversion in Datastage?
Which commands are used to import and export the datastage jobs?
What is difference between join, merge and lookup stage?
What are the different options associated with dsjob command?
What are the benefits of datastage?
What are the repository tables in datastage?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are the functionalities of link collector?
Can you define merge?
What are the types of containers?
