Hi All can anyone tell me where i will get Informatica
training in Mumbai?
Answer Posted / patti
You will get the best Informatica training online at
trainovation.com
The instructor is great and the price is affordable.
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is meant by active and passive transformation?
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
Explain Dataware house architecture .how data flow from intial to end?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
what is the hint? how to use it to reduce the query processing in program?
How to extract sap data using informatica? What is abap? What are idocs?
What is informatica?
What is the use of an aggregator cache file?
whats the logic to load the lower level of granularity of data to fact table.
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What does update strategy mean, and what are the different option of it?
What is Data Caches size?
difference between informatica 8.1.1 and 8.6
How many types of sessions are there in informatica.please explain them?