how can we update without using update transformation.
wt is push down operation in informatica.
which lookup gives more tuning performance. if so why.
Answer Posted / gyana
GOOD WORK USHA
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How to load data in informatica ?
What are ETL Tools?
How can we use batches?
Mention few advantages of router transformation over filter transformation.
expain about the tune parameters?
list out all the transformations which use cache?
What is informatica powercenter repository?
What is target designer and target load order?
What is primary and backup node?
What are the prerequisite tasks to achieve the session partition?
What is a surrogate key?
How do you remove duplicate records in informatica? And how many ways are there to do it?