Interested to Buy Any Domain ? << Click Here >> for more details...
How can you join flat file, oracle as a sources?
- 4 Answers
- 12654 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
Why fact table is in normal form?
Difference between data warehousing and olap?
What is a merge?
Differentiate between datastage and datastage tx?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Why do we use link partitioner and link collector in datastage?
What are stage variables?
What is the use of hoursfromtime() function in transformer stage in datastage?
How to reverse the string using unix?
What is the difference between orabulk and bcp stages?
What is the method of removing duplicates, without the remove duplicate stage?
What are orabulk and bcp stages?
What is the roundrobin collector?
What is the precedence of stage variables,derivations, and constraints?
Explain usage analysis in datastage?
