Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / haritha reddy
It is the temparory storage area where the reconcilation of
data is possible.
you can extract the data from diff source systems and
transform,you can aggregate, cleans the data.
staging area reduce the burden on the source system.
| Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
What are the different clients of powercenter?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Is stop and abort are same in informatica?
Could you explain what is enterprise data warehouse?
What is a difference between complete, stop and abort?
What is a pre-defined event and user-defined event?
What do you mean incremental aggregation?
What are the components of Informatica? And what is the purpose of each?
How can you generate reports in informatica?
Explain in detail scd type 2 through mapping.
What are active and passive transformations?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is different between the data warehouse and data mart?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
