Interested to Buy Any Domain ? << Click Here >> for more details...
I cleared Informatica certification Designer. if anybody
need dumps, can contact at mukesh1009@gmail.com
- 119 Answers
- 120498 Views
- Accenture, Gcs, TCS, I also Faced
- E-Mail Answers
Answer Posted / prasad
Hi,
This is prasad,
Please send me the dump to prasad_svn84@yahoo.com
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
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 do you migrate data from one environment to another?
difference between informatica 8.1.1 and 8.6
In warehouses how many schemas are there?
Explain the aggregator transformation?
Enlist the differences between database and data warehouse.
How can you validate all mappings in the repository simultaneously?
While migrating the data from one environment to another environment how would you manage the connections?
what is SDLC way of code development?
Differentiate between router and filter transformation?
scenario where i can use only concurrent execution of workflow.
Can you use flat files in Mapplets.
How can one identify whether mapping is correct or not without connecting session?
How do you handle two sessions in Informatica
