How can you join flat file, oracle as a sources?
Answer Posted / kalyanreddy
Hi Vijay,
first populate flatfile data to orale db
two methods,
1. write a join query in source oralce stage and link to
target.
2. take two oracle sources like s1 and s2 , use join stage
and link to target
or
direct method
3.take flat file and oracle source, use join stage and link
to target.
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
how many rows sorted in sort stage by default in server jobs
What is quality stage?
How do you start developing a datastage project?
What are the types of containers and how to create them?
Have you have ever worked in unix environment and why it is useful in datastage?
Differentiate between data file and descriptor file?
Why do we use link partitioner and link collector in datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What is "fatal error/rdbms code 3996" error?
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
options available in sequence job to run,validate?
What is difference between symmetric multiprocessing and massive parallel processing?
AGGREGATOR default datatype
Why we use surrogate key?