What are variable ports and list two situations when they can be used?
Answer Posted / thotli
variable port is it stores the variable value after data flow also.
1)when we separate unique records and duplicate values
2)when we develop ranks without rank transformation
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Performance tuning in UNIX for informatica mappings?
Differentiate between a repository server and a powerhouse?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is an Integration service in Informatica?
According to his methodology what all you need before you build a datawarehouse
Sequence generator, when you move from develoment to production how will you reset
Explain lookup transformation in informatica
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
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 we can load rejected record's at run time?(not through bad files)
What is source qualifier transformation in informatica?
Mention some types of transformation?
What is the function of aggregator transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.