What is an aggregator transformation? it is active why cant
it be passive explain?
Answer Posted / rajan raorane
1)Agregator T/R is used to perform summary calcluation
2) It is Active bcoz the output of this T/R is not equal to
input
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to generate sequence numbers using expression transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Do you find any difficulty while working with flat files as source and target?
Enlist the various types of transformations.
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
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
What is olap (on-line analytical processing?
What are the static cache and dynamic cache in informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How many ways are there to do 'remove duplicate records in informatica'?
what is degenerated dimension?
Define filter transformation?