how to remove staging area
- 1 Answers
- 5167 Views
- I also Faced
- E-Mail Answers
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 |
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
lookup transformation with screenshots
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
Explain the use of aggregator cache file?
What is the benefit of partitioning a session?
How do you remove duplicate records in informatica?
What is the use of source qualifier?
performance wise which one is better in joiner and lookup transformation
What are the mapping parameters and mapping variables?
State the limitations where we cannot use joiner in the mapping pipeline?
What are the new features in Informatica 5.0?
What is a node in Informatica?
Teradata 
