Answer Posted / sanjay
Informatica issue a status code when it's run the stored
precedure transformation , it is use for error handling of
store procedure .
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
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?
What is the different lookup cache(s)?
Explain how to import oracle sequence into informatica?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Enlist few areas or real-time situations where informatica is required.
How to improve the performance of a session using sorter transformation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Write the program through which the records can be updated?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Explain lookup transformation in informatica
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is a sequence generator transformation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Mention few advantages of router transformation over filter transformation.
What is the meaning of decode in informatica?