What's the Main Function of the Staging area in DWH
Answer Posted / chandan.g
STAGING AREA is nothing but a temporary memory (resting area ) of the data which is converted initially from the source we get and can be converted into the desired format
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What are orabulk and bcp stages?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the method of removing duplicates, without the remove duplicate stage?
In Datastage, how you can fix the truncated data error?
What is oci?
How can we improve the performance in datastage?
Differentiate between odbc and drs stage?
Nls stands for what in datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are the different layers in the information server architecture?
How a routine is called in datastage job?
How and where you used hash file?
What are system variables and sequencers in datastage