Explain about Recovering sessions?
Answer / swetha
If you stop a session or if an error causes a session to
stop, refer to the session and error logs to determine the
cause of failure. Correct the errors, and then complete the
session. The method you use to complete the session depends
on the properties of the mapping, session, and Informatica
Server configuration.
Use one of the following methods to complete the session:
Run the session again if the Informatica Server has not
issued a commit.
Truncate the target tables and run the session again if the
session is not recoverable.
Consider performing recovery if the Informatica Server has
issued at least one commit.
| Is This Answer Correct ? | 1 Yes | 1 No |
Suppose we do not group by on any ports of the aggregator what will be the output?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
Which is the t/r that builts only single cache memory?
Differentiate between a repository server and a powerhouse?
which transformation uses cache?
Explain what are the different types of transformation available in informatica.
Why we require dwh in particular projects?
what is the process we used in joiner transformation,there is no matching column in sources?
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
I need an oracle query for convert Char to Integer?. Can any one help me how to do this?
what is $$$$?