In which circumstances that informatica server creates
Reject files?
Answers were Sorted based on User's Feedback
Answer / swetha
When it encounters the DD_Reject in update strategy
transformation.
Violates database constraint
Filed in the rows was truncated or overflowed.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / girish
When the data in the file, may be tab separated, is
incorrect. i.e. if there is an extra tab for a set of
records and this is making the text data come under a
numeric column, this violates the datatype and the source
file is rejected.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is update override?
Explain why we use partitioning the session in informatica?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
Clarify the aggregator change?
How the informatica server sorts the string values in Rank transformation?
if the session fails after 100 records agian we have to starts the session or we go for recovery session
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Enlist the tasks for which source qualifier transformation is used.
What is a candidate key?
Whats there in global repository
Can anyone briefly describe abt audit table loading?
Which one is better performance wise connected/un-connected lkp?why?