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
Answer Posted / 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 |
Post New Answer View All Answers
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is a merge in datastage?
What are the important features of datastage?
How rejected rows are managed in datastage?
what is flow of project?
How to RD using transformer?
Explain connectivity between datastage with datasources?
What is the difference between odbc and drs stage?
EXPLAIN SCD
What are the different plug-ins stages used in your projects?
Explain Quality stage?
What are the types of hashed files in data stage
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr