Interested to Buy Any Domain ? << Click Here >> for more details...
If the records doesnt satisfy the filter condition where
will it go?
- 10 Answers
- 15872 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ankit kansal
The filtered records will not be written into reject file. Only when data consistency erros or some parsing error occurs, then the records will be move to reject file. In your case PRODUCT_COST value 12 will be filtered out from the mapping flow.
http://deepinopensource.blogspot.com/
| Is This Answer Correct ? | 0 Yes | 0 No |
If the Filter codition doesn't match those records are sent to Bad files. you can check the Bad File in infromatica server directory i.e., C:Informatica10.1.0serverinfa_sharedBadFiles
and the filename is targetFilesname with extention .out
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / praveen
When Ever u apply ur condition it will receive only required condition records.It will not remain others means it will not store in any where.
| Is This Answer Correct ? | 7 Yes | 8 No |
Answer / sara
If the records doesnt satisfy the filter condition. Those
records does not stored anywhere.
| Is This Answer Correct ? | 5 Yes | 6 No |
Answer / venky
if the records doesnot satisfied the filter condition,that
will not pass,it will stop at the filter transformation,it
will not store at anywhere
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / subhransu
The Very Simple Answer "The Records are Rejected". They dont store anywhere.
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / basava
If the records does not satisfy the filter condition then
those records will be stored in $pmbadfile location in
informatica. This is the default path provided by
informatica, you can override this path in session properties.
| Is This Answer Correct ? | 2 Yes | 7 No |
What is workflow? What are the components of the workflow manager?
how we can load rejected record's at run time?(not through bad files)
Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........
Define mapplet?
Explain sessions. Explain how batches are used to combine executions?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
Define joiner transformation?
What is an active transformation?
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
what is the purpose of surrogate key and diff between primary key&surrogate key
Teradata 
