Hi Deepak, spelling of grammar is grammar not grammer. :-)

how can we perform incremental aggregation?explain with
example?

Question Posted / archie

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

Answer Posted / archie

Hi Deepak,

spelling of grammar is grammar not grammer.

:-)

Is This Answer Correct ?

14 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How is union transformation utilized?

948

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2048

Did u used latest transformations of 8.6.0? for what?

1820

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

What will be the approach?

927

What if the source is a flat-file?

1041

How do you convert single row from source into three rows into target?

1090

How you prepared reports for OLAP?

1542

Please let me know how to make Data masking in informatica..

1658

Differences between version 7.x and 8.x.

1839

Explain the mapping variable usage example in informatica

1079

How might one distinguish in the case of mapping is right or not without associating session?

1017

What is the use of an aggregator cache file?

1133

scenario where i can use only concurrent execution of workflow.

3061

What happens when a session fails and you click on recover?

1054