What's the Main Function of the Staging area in DWH
Answer Posted / saikiran katari
staging area is a temporary storage area.which is loaded with all the transaction data and while loading in to staging area we are not suppose to perform single transaction activity..
if i am telling is wrong..send me current answer my mail..
mail id: katari079@gmail.com
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is the use of hoursfromtime() function in transformer stage in datastage?
What is apt_config in datastage?
in oracle target stage when we use load option and when we use upsert option?
Describe the architecture of datastage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Describe the main features of datastage?
Define meta stage?
What is difference between symmetric multiprocessing and massive parallel processing?
How complex jobs are implemented in datstage to improve performance?
What are datastage sequences?
How do you import and export data into datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this