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
- 7269 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 is oci?
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
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Which commands are used to import and export the datastage jobs?
What are system variables and sequencers in datastage
What is the difference between Datastage 7.5 and 7.0?
what are the devoleper roles in real time? plz tell i am new to datastage....
What is the difference between account and directory options ?
how to write server Routine coding?
What is "fatal error/rdbms code 3996" error?
What are the partitioning techniques available in link partitioner?
explain about citrix scheduling tool in datastage
Can you define merge?
How a source file is populated?
What are the various kinds of the hash file?
