Interested to Buy Any Domain ? << Click Here >> for more details...
How can you join flat file, oracle as a sources?
- 4 Answers
- 12913 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
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
what is the difference between == and eq in UNIX shell scripting?
Describe the main features of datastage?
How can we improve the performance in datastage?
What all the types of jobs you developed?
Define Routines and their types?
Define project in datastage?
What are the partitioning techniques available in link partitioner?
Where the datastage stored his repository?
What is usage analysis in datastage?
What is the difference between informatica and datastage?
what is repositery?
Define orabulk and bcp stages?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are the types of containers in datastage?
