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 |
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
what is snow flack schema?
job locking methods? How can we unlock the job?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA
1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
source contains 2 columns comes to target 4 columns how
i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc Ple help any one?
whats relation between configuration file and datasets?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
what is a force compile