how to remove staging area



how to remove staging area..

Answer / sunil

)At DB level we can simply DROP the stagin table.
2)then Create Target table at DB level.
3) Directly LOAD the records into target table.

NOTE: It is recommended to use staging area

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,


I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  


What aer the out put files that the informatica server creates during the session running?

4 Answers  


In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 Answers  


Write the unconnected lookup syntax and how to return more than one column.

0 Answers  






waht is dataware house

2 Answers  


What are active and passive transformations?

0 Answers   Informatica,


i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater

5 Answers  


What is meant by lookup transformation?

0 Answers  


where to store informatica rejected data?

0 Answers  


What are the Differences between connected and unconnected lookup?

6 Answers   TCS,


permutations of mapplet

0 Answers   TCS,


Categories