Answer Posted / n.bandaru
Yes, I agree above answers.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is source qualifier transformation in informatica?
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?
What are the different transaction levels available in transaction control transformation?
What is a rank transform?
What are the prerequisite tasks to achieve the session partition?
How many dimensions are there in informatica?
Write the unconnected lookup syntax?
How many types of sessions are there in informatica.please explain them?
How do you load only null records into target? Explain through mapping flow.
Define the various join types of joiner transformation?
What is primary and backup node?
What all join we can perform in LOOKUP transformation?
Does an informatica transformation support only aggregate expressions?
Informatica Checkpoints
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?