Interested to Buy Any Domain ? << Click Here >> for more details...
What is incremental aggregation and how it is done?
- 8 Answers
- 39150 Views
- JPMorgan Chase, TCS, I also Faced
- E-Mail Answers
Answer Posted / bharat
Incremental aggregation is a technique by which we can
capture the aggregated data incrementally.
for this we have to sort the data before sending it to
aggregator then we have to enable the property incremental
aggregation in the workflow level inside the session.
| Is This Answer Correct ? | 11 Yes | 9 No |
Post New Answer View All Answers
What differs when we choose the sorted input for aggregator transformation?
During the running session, output files are created by informatica server. Enlist few of them.
What are the uses of etl tools?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are the tasks that can be performed using sq?
Which version configuration tool used in ur project?
What do you mean by channel change?
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
what is SDLC way of code development?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How do you handle two sessions in Informatica
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
In which transformation you cannot drag ports into it?
is it possible to index the data in cache of lkp transformation ?
