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
Explain pushdown optimization $pushdownconfig parameter - informatica
What is the maplet?
Can we create a Integration service without a Repository service and vice versa?
Define joiner transformation?
What is difference between a gateway node and worker node?
How many numbers of sessions can one group in batches?
What are the advantages of informatica?
What is repository manager?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What does “tail –f” command do and what is its use as an Informatica admin.
What is intricate mapping?
What is informatica worklet?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How do we call shell scripts from informatica?