Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / lakshminarayana
intermediate area between source system and data warehouse.it is temporary schema/user.after completion of each session we have to delete the previous data from staging area(table) before going to load data into staging area.it is used mainly for the purpose of increase the performance of source system means we perform join condition it will take lot of time to execute because join perform on the total data of table.but staging area required particular condition data means it required small amount data not the total copy of source data.and it used for clean the data before loading.it is relational data base.no end user can't access the data and no transformation perform on the staging area.if the session will failure then we directly receive particular data from staging area.means we can decrease the burden on source by using staging area.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to go to the older version for a mapping?
What does reusable transformation mean?
What is the difference between informatics 7x and 8x and what is latest version?
What is the sequence generator transformation in informatica?
Target increases every day even though no new record was inserted
How do we call shell scripts from informatica?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is the Process to creating lookup transformation in informatica
Enlist the various types of transformations.
I have a flat file, want to reverse the contents of the flat file
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
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is enterprise data warehousing?
Explain the different kinds of facts.
Name the different lookup cache(s)?
