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
- 8208 Views
- Wipro, I also Faced
- E-Mail Answers
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 explain players in datastage?
Enlist various types of routines in datastage.
How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What are the differences between datastage and informatica?
what is a force compile
in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh
Explain the functionality of your current project?
1 Answers IBM, Miles Software,
1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME
how CAN we remove duplicates in dataset?
Teradata 
