How can you join flat file, oracle as a sources?
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 |
what is a message handler
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?
Define repository tables in datastage?
6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment
Why we use surrogate key?
in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....
i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?
What are the partition techniques available in your last project?
on how many columns we can perform aggregation in the aggregator stage?
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
explain about citrix scheduling tool in datastage
Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks