By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?

Answer Posted / priya

Well You can Use Router iif you need rejected rows along
with satisfied rows otherwis you just give the condition
for filter tx as you want it in your target table.

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1336


Differentiate between sessions and batches?

574


What is resilience time?

655


What is olap (on-line analytical processing?

641


What is the need for an etl tool?

637






What is the Process to creating lookup transformation in informatica

585


Explain about cumulative Sum or moving sum?

620


What is the meaning of decode in informatica?

646


What is the use of target designer?

610


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

3450


Can anyone tell me the new features in Informatica 9 Version?

1532


What do you mean by blocking transformation?

585


What are the conditions needed to improve the performance of informatica aggregator transformation?

583


What is informatica etl tool?

554


What is pmcmd command?

677