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

Answer Posted / nikunj

Don't use filter transformation.

Router transformation is a better option in this scenario.

Is This Answer Correct ?    50 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between sessions and batches?

578


What is the function of aggregator transformation?

582


Explian the Process of deployment groups in informatica

659


What are connected or unconnected transformations?

630


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1658






Differentiate between source qualifier and filter transformation?

1003


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1635


To import the flat file definition into the designer where should the flat file be placed?

681


What is primary and backup node?

706


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1780


Explain direct and indirect flat file loading (source file type) - informatica

837


What is the function of look up transformation?

655


Differentiate between a database and data warehouse?

656


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1699


Explain the aggregator transformation?

631