How can you join flat file, oracle as a sources?
- 4 Answers
- 13118 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kiran
hai vijay..,
See Whats the Question and please first clear ur
questions.then give proper answer boss.by using flat files
also u can join and populated to target.please clear ur
quetion.
Thanks & Regards
Kiran
09393363309
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / bharathd
By using Seqfile stage(flat file) and Oracle(Dynamic RDBMS
stage)to extract the data from sources, the join the data
using join stage.
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain briefly scd type2 in datastage7.5x2(parallel)
How do you load dimension data and fact data? Which is first
How do you generate sequence number in datastage?
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
State the difference between an operational datastage and a data warehouse?
i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00
How will you move hashed file from one location to another location?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What are the types of containers in datastage?
where we use column generator stage in real time scenario?
How can you write parallel routines in datastage PX?
1.What is a delta record? How you will read it? 2.What are the different types of sorting?
Teradata 
