Interested to Buy Any Domain ? << Click Here >> for more details...
How can you join flat file, oracle as a sources?
- 4 Answers
- 13015 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
How a server job can be converted to a parallel job?
What are the areas of application?
EXPLAIN SCD
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What are the types of containers and how to create them?
What are some prerequisites for datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
Define Routines and their types?
What are iconv and oconv?
Explain entity, attribute and relationship in datastage?
How do you register plug-ins?
how to implement scd2 in datastage 7.5 with lookup stage
How to Remove Duplicate using SQL?
What is the use of datastage designer?
What is meta stage?
