using update stratagey tr (or)session properties both are same.update strat

why do we go for update strategy tr in SCD rather using the
session properties?

Question Posted / akhil4

3 Answers
16951 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / akhil4

using update stratagey tr (or)session properties both are same.update stratagey using at mapping level,session properties using at wf level. (it's wrong correct me)

Is This Answer Correct ?

1 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the differences between oltp and olap?

961

Is it possible to use a client with different version than that of its Informatica server?

1122

What is the sequence generator transformation in informatica?

1161

What is the advantage of informatica?

1055

tell me the rules and responsblites in our project(my project is development)

1918

What is fact table? Explain the different kinds of facts.

1063

Is it possible to revert a global repository to local one and why?

1064

How can we handle two sessions in informatica?

1019

What is the use of code page?

1068

what is INFORMATICA TESTING process

2276

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

9068

What is informatica powercenter repository?

1171

Can we create a Integration service without a Repository service and vice versa?

1204

How to open an older version of an object in the workspace?

1188

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1264