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 3 tech challenges/ common issues you face?
What is transformation?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is domain and gateway node?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What do you mean by worklet?
How we can use union transformation?
How can we delete duplicate rows from flat files?
What is meant by lookup transformation? Explain the types of lookup transformation?
What all join we can perform in LOOKUP transformation?
Explain how to import oracle sequence into informatica?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What do you mean incremental aggregation?
What is a dimensional model?
