What is staging area?

Answer Posted / k raju

Staging area is we kept all data From OLTP with offline mode
in staging area where we made datacleansing and ready for
transformation

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the Process to creating lookup transformation in informatica

733


What are the differences between oltp and olap?

671


whats the logic to load the lower level of granularity of data to fact table.

1976


What is a difference between complete, stop and abort?

790


What is the sequence generator transformation in informatica?

810






hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1827


How do you load only null records into target? Explain through mapping flow.

1703


What can we do to improve the performance of informatica aggregator transformation?

793


What is lookup change?

744


what is the size of your data warehousing?

1814


CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

8288


How to start a workflow using pmcmd command?

865


Enlist few areas or real-time situations where informatica is required.

757


Explain scd type 3 through mapping.

737


What are the various types of transformation?

813