Answer Posted / swetha
Status code provides error handling for the informatica
server during the session. The stored procedure issues a
status code that notifies whether or not stored procedure
completed sucessfully. This value can not seen by the user.
It only used by the informatica server to determine whether
to continue running the session or stop.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to do unit testing in informatica? How to load data in informatica ?
How we can use union transformation?
Can you generate sequence numbers without using the sequence generator transformation?
What are the designer tools for creating transformations?
How do you handle two sessions in Informatica
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
While migrating the data from one environment to another environment how would you manage the connections?
In development project what is the process to follow for an etl developer from day1
Scheduling properties,whats the default (sequential)
In which transformation you cannot drag ports into it?
Why update strategy and union transformations are active? Explain with examples.
What is persistent lookup cache?
What are the reusable transformations?
What are the informatica performance improvement tips
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?