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
- 8215 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 |
WHAT IS FORCE COMPILE?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are the functionalities of link partitioner?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???
how to call sequential generator in datastage?
if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA
explain about citrix scheduling tool in datastage
Notification Activity
what is the Difference Between Datastage Server Edition and Parallel Edition?
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Teradata 
