What is incremental aggregation and how it is done?

Answer Posted / vas chiky

If suppose, i use a dynamic lookup of target agg table and
an update stategy to update or insert records.. what is the
difference between this and Incremental aggregation ?? why
i need to depend on this Incremental aggregation chk box??

please clear my doubt

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the scenario which compels informatica server to reject files?

674


What is a transaction control transformation?

833


What is a surrogate key?

643


How does a sorter cache works?

638


Explain the informatica workflow?

665






What are the different components of powercenter?

651


HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1772


What do you understand by a term domain?

740


What is meant by LDAP users?

758


What do mean by local and global repository?

782


How might you approve all mappings in the archive all the while?

671


Explain what is informatica metadata and where is it stored?

671


How many numbers of sessions can one group in batches?

679


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1532


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

1756