Hi
I have been asked several times the following questions.
1.How does one do incremnental loading
2.Scenario - You are trying to load reasonable amount of
rows into the target table, and its taking a helluva lot of
time.What could be the reasons?
I hate to answer these tw0 , gives me nightmares to even
think of it!!!
3.Tell me any complex situation you have faced( as an
Informatica Developer) and how did you resolve it.
4.tell me any complex mapping that you have done.
All the experienced people out there , please please, reply
to these questions.
- 2 Answers
- 7803 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhinaw prakash
Answer
1.We can do incremental loading by clicking on the check box inside Aggrgator T/R.Use filter transformation before Aggrgator to filter out rows and pass only the changed records to the flow.
2.One of the reasons could be the time its taking to build caches.to answer this more details of the maping is required.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a dimensional model?
How to elaborate powercenter integration service?
How we can create indexes after completing the loan process?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
In informatica workflow manager, how many repositories can be created?
Explain what are the different versions of informatica?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
server hot-ws270 is connect to Repository B. What does it mean?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are the performance considerations when working with aggregator transformation?
have u done any performance tuning? how u ll do?
Explain the types of transformations?
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,
How many transformations can be used in mapplets.
What is joiner transformation in informatica?
