Its a session option. when the informatica server performs incremental aggr

how can we perform incremental aggregation?explain with
example?

Question Posted / appireddy

9 Answers
23248 Views
IBM, TCS, I also Faced
E-Mail Answers

Answer Posted / appireddy

Its a session option. when the informatica server performs incremental aggr. it passes new source data through the mapping and uses historical chache data to perform new aggregation caluculations incrementaly. for performance we will use it.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is transformation?

1049

Is it possible to create multiple domains on a single Informatica server?

1174

Which transformation should we use to normalise the COBOL and relational sources?

1138

How to Create a folder using pmrep command?

1101

Explain your project of banking domian.

1605

What is the sequence generator transformation in informatica?

1092

What is persistent lookup cache?

965

What is the procedure for creating independent data marts from informatica 7.1?

997

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

8934

Under which circumstances, informatica server creates reject files?

1023

How to generate sequence numbers using expression transformation?

1025

What is meant by LDAP users?

1107

 Informatica Checkpoints

3264

What is a sequence generator transformation?

950

list out all the transformations which use cache?

1111