Interested to Buy Any Domain ? << Click Here >> for more details...
How can you join flat file, oracle as a sources?
- 4 Answers
- 12891 Views
- IBM, I also Faced
- E-Mail Answers
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
table actions available in oracle connector?
Differentiate between datastage and datastage tx?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is "fatal error/rdbms code 3996" error?
What is the difference between operational data stage (ods) and data warehouse?
Define Job control?
what is repositery?
What is the purpose of pivot stage and types of containers in datastage
Define Merge?
How many types of stage?
What is a quality stage in datastage tool?
What are iconv and oconv?
project Steps,hits, Project level HArd things,Solved methods?
What is difference between symmetric multiprocessing and massive parallel processing?
Define data aggregation?
