Interested to Buy Any Domain ? << Click Here >> for more details...
In which circumstances that informatica server creates
Reject files?
- 2 Answers
- 8013 Views
- I also Faced
- E-Mail Answers
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 |
without matching columns in two tables. how can you join
What are session parameters ? How do you set them?
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
What is status code?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
What all join we can perform in LOOKUP transformation?
What do you mean by blocking transformation?
What is target load order?
What are the differences between joiner transformation and source qualifier transformation?
What is the benefit of session partitioning?
which quality process u can approach in ur project
Teradata 
