Answer / gyana

exactly
with out 0 1 2 3,if u enter any number then update_strategy t/r INSERT the record.....if you enter 10 dn also insert only

Answer / sham

if we give any other value the integration service will
treat any other value as an INSERT.

Answer / manjunath

in update strategy flag 4 means INSERT.


0 Insert
1 Update
2 Delete
3 Reject.
if we give any other value the integration service will
treat any other value as an INSERT.

Answer / madhu

in update strategy t/r other than (0,1,2,3) what ever it may
be numeric integration service flags the row to insert.

Answer / siva

There is no meaning for 4 in Update Strategy.

0 Insert
1 Update
2 Delete
3 Reject

Answer / chandrasekar

I think Flag 4 means DD_REJECT. It wont send any records to
target.

If i wrong means please mail me at chandranmca2007@gmail.com

What is the difference between informatica 7.0 and 8.0?

0 Answers  

what is workflow varible

1 Answers   HP,

generate date / time dimension in informatica

0 Answers   Informatica,

scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,

Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it

1 Answers  

.prm wirh repalce .txt is possible?

2 Answers  

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

5 Answers   BirlaSoft,

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

4 Answers   CSC,

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

0 Answers  

wat are deployement groups in informatica, how it will be used for developers

0 Answers  

What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,