Informatica - How do we delete staging area in our project?

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 428 of 630

How do we delete staging area in our project?

Total Answers and Comments: 3

Last Update: March 15, 2007 Asked by: anil

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

November 15, 2006 03:59:08

narayana

RE: How do we delete staging area in our project?

If your database is oracle then we can apply CDC(change data capture) and load data which is only changed recently after previous data load.

Is this answer useful? Yes | No

November 28, 2006 14:56:10

pushpam vaidya

RE: How do we delete staging area in our project?

if staging area is storing only incremental data ( means changed or new data with respect to previous load) then you can truncate the staging area.

But if you maintain historical information in staging area then you can not truncate your staging area.

Is this answer useful? Yes | No

March 15, 2007 12:23:47

Aparna

RE: How do we delete staging area in our project?

If we use Type 2 of slowly changing dimensions we can delete staging area. because SCD Type 2 stores previous data with version number and time stamp.

Is this answer useful? Yes | No

Go To Top