I cleared Informatica certification Designer. if anybody
need dumps, can contact at mukesh1009@gmail.com
Answer Posted / pavan
Hi Mukesh,
Can you send me the dumps to my mail I'd:
pavankumar120589@gmail.com
Thanks in advance
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the -ve test case in your project.
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Enlist the advantages of informatica.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the guidelines to be followed while using union transformation?
What is joiner transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is data caches/ index caches?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How to differentiate between the active and passive transformations?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
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
What is sq transformation?
What are session parameters ? How do you set them?
What is mapping debugger?