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.
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 could be the possible resons of locks by user?
Explain sessions and how many types of sessions are there?
How do you load only null records into target? Explain through mapping flow.
What is workflow? What are the components of workflow manager?
What is the need of an ETL tool?
Explain load alternative records / rows into multiple targets - informatica
Explain pmcmd command usage in informatica
What can we do to improve the performance of informatica aggregator transformation?
What are the different versions of informatica?
How to extract sap data using informatica?
Explain the aggregator transformation?
What is an expression transformation in informatica?
What is informatica metadata and where is it stored?
What is intricate mapping?
What is a sequence generator transformation?