What will happen if we have a filter transformation used in
a mapping and in the filter condition we specify 1. Yes
nothing else, only the number 1. In other words, assuming we
have 10 rows coming to this filter transformation as an
input, how many rows will be output by this transformation
when we have only 1 in the filter condition?
Answer Posted / pavan
THE FILTER CONDITION IS 0 THE SESSION WILL BE FAIL
THE FILTER CONDITION IS NON ZERO MEANS LIKE 1,2,3....IS TRUE THEN IT PROCESS ALL THE ROWS WITH OUT FILTERING ANY DATA
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can we override a native sql query within informatica?
What is a standalone command task?
Explain the code page compatibility?
Why sorter is an active transformation?
Is there any target staging area in informatica not staging area
what are 3 tech challenges/ common issues you face?
Explain the pipeline partition with real time example?
What is source qualifier transformation in informatica?
Can you generate sequence numbers without using the sequence generator transformation?
What is transformation?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is aggregator transformation in informatica?
What is union transformation?
COM components can be used in Informatica
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.