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
What is the Process to creating lookup transformation in informatica
What are the differences between oltp and olap?
whats the logic to load the lower level of granularity of data to fact table.
What is a difference between complete, stop and abort?
What is the sequence generator transformation in informatica?
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
How do you load only null records into target? Explain through mapping flow.
What can we do to improve the performance of informatica aggregator transformation?
What is lookup change?
what is the size of your data warehousing?
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
How to start a workflow using pmcmd command?
Enlist few areas or real-time situations where informatica is required.
Explain scd type 3 through mapping.
What are the various types of transformation?