can we import source table without using source qualifier? if
yes then how? if no then why?
Answers were Sorted based on User's Feedback
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
Hi experts, can anyone tell how much we use plsql in real time
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
If informatica has its scheduler why using third party scheduler?
Define error Threshold?
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 target load order?
How to jion 2 tables, without using any condition?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
How to generate sequence numbers using expression transformation?
pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?