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 issues you have faced in your project? How did you overcome those issues?
Why sorter is an active transformation?
How many ways a relational source definition can be updated and what are they?
Clarify the utilization of aggregator cache record?
What is an active transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What are the different options available for update strategy?
What is the need of etl tools?
Can we create multiple integration service on single repository?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is informatica metadata and where is it stored?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How will the document be delivered to me?
What are the tasks that source qualifier perform?
