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
- 8169 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
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Define Job control?
how to implement scd2 in datastage 7.5 with lookup stage
How you Implemented SCD Type 1 & Type 2 in your project?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
what is the difference between == and eq in UNIX shell scripting?
What is the use of datastage designer?
How can one find bugs in job sequence?
Explain entity, attribute and relationship in datastage?
Define data aggregation?
What is aggtorec restructure operator?
What are the primary usages of datastage tool?
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
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is the use of datastage director?
