In which circumstances that informatica server creates
Reject files?
- 2 Answers
- 7230 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 |
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is a filter transformation?
how tokens will generate?
What is update override?
plz plz plz send client names and project names in informatica?
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
Explain the pipeline partition with real time example?
Why we need XMLs?
Is there any way to read the ms excel datas directly into informatica?
In development project what is the process to follow for an etl developer from day1
What is the command used to run a batch?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Teradata 
