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 are the types of schemas we have in data warehouse.
What is mapplet in informatica?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How do you set a varible in incremental aggregation
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How might one distinguish in the case of mapping is right or not without associating session?
explan ur project architecture?
What does command task mean?
What do you mean incremental aggregation?
Define mapping and session?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How do you use reject loader.
What is meant by lookup transformation?
What are active and passive transformations?
How to improve the performance of a session using sorter transformation?