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 |
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is informatica? What exactly are the practical uses in real world
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
how many types of dimensions are available in informatica?
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
What is parallel processing in informatica?
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.
What are Dimensional table?
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?