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 session task and command task?
can we override a native sql query within informatica? Where do we do it?
How does a rank transform differ from aggregator transform functions max and min?
What is the difference between view and materialised view?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
In Which scenario did u used Incremental loading?
Where do you create/define mapping parameter and mapping variable?
How to elaborate powercenter integration service?
What is difference macros and prompts?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.