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
On which transformations you created partitions in your project?
Write the unconnected lookup syntax?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is a grid in Informatica?
What is a predefined event?
What is the Process to creating lookup transformation in informatica
What are session parameters ? How do you set them?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are the popular informatica products?
What are roles and groups and benefits of using them?
Explain constraint based loading in informatica
What is decode in static cache?
What are the informatica performance improvement tips
What does command task mean?
What is event and what are the tasks related to it?