Update strategy transformation is an active
transformation.How it changes the number of records that
pass through it? Please explain....
Answer Posted / kondareddy
for example take one condition in update strategy
source we have 20 records. in that records we have 4 records has less then 500 salary
in update strategy condition is
iif(sal<500,3,sal) based on that condition only 15 records stored into target. so it will be effected on rows. becoz in update strategy 3 indicates rejected records....
so it is active....
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is a dimensional model?
How do you update the records with or without using update strategy?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is a standalone command task?
Explain sql transformation in script mode examples in informatica
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Could you explain what is enterprise data warehouse?
where to store informatica rejected data? How to extract the informatica rejected data?
What is an expression transformation in informatica?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How you prepared reports for OLAP?
What is aggregator transformation in informatica?
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
Repository user profiles