How we will implement Pushdown Optimization and Types in Informatica with better examples
Answer Posted / abhinaw prakash
Just to add on the above points.We cannot decide which
transofrmation logic to send to the Database.The
integrations service decides which login to send to the
database to optimize the process.although we can see the
sql logic in the Pushdown priview and the messages and
warning attached to it.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to update or delete the rows in a target, which do not have key fields?
can anyone explain me about retail domain project in informatica?
Mention some types of transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How we can use union transformation?
How to load last n records of file into target table - informatica
How to join three sources using joiner? Explain though mapping flow.
What is rank transformation in informatica
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain the etl program with few examples.
What is rank transform?
How to update source definition?
How do you load unique records into one target table and duplicate records into a different target table?