Interested to Buy Any Domain ? << Click Here >> for more details...
I have a condition sal=100 and I created one router and in
that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100,
first which condition will satisfy, and Why?
- 11 Answers
- 25096 Views
- I also Faced
- E-Mail Answers
Answer Posted / ram patil
Only display record both conditions are not executed
SQ->FILTR->RTR>TRG1>TRG2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many ways are there to do 'remove duplicate records in informatica'?
What is intricate mapping?
Where are the source flat files kept before running the session?
how to create user defined function (udf) in informatica
What is the use of source qualifier?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Difference between Data and Index Caches?
What is an expression transformation in informatica?
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.
What are the different types of olap? Give an example?
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 informatica metadata?
What is a repository manager?
what is the size of your data warehousing?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
