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
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 |
How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?
What is a datastage job?
What are the repository tables in datastage?
How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
i have the source from Uk,north america how can i pass the data two tables based on the locations
Give an idea of system variables.
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
What is job control?
How many number of reject links merge stage can have?
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
how many types of sorting the data in data stage?
HOW CAN WE SEE THE DATA IN DATASET?
12 Answers IBM, TCS,