Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

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




1251
views
asked marvit September 20, 2014 08:05 AM  

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


           

1 Answers



 
answered By vishnoiprem   0  
You can use filter transformations to filter rows. Filter transformations passes rows to next transformation which rows met the condition. But it cannot pass rows which rows doesn't meet the condition. It means, it does not maintain dropped rows of data(discards rows of data). so you cannot pass dropped rows of data to another transformations. You want to pass dropped rows of data to another transformations you need to use the Router transformation. The Router transformation has default group so it gives an option to route the rows which not meet condition to default group.We can use the one router transformation instead of multiple filter transformation.

its not good work environment by using multiple filter t/r usage

Any way by using multiple filter we can load rejected rows also
SD-->SQ-->fltr(condition(true)(eg:dept no=10)---->loaded into one target
|___..>fltr(condition(False)(eg:dept no!=10)--->loaded into another Target(rejected rows)
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert