for ex: in source 10 records are there with column sal. use
a filter transformation condition as Sal=TRUE and connect
to target. what will happen.

Answer Posted / venkat

hi guys ans 3 totally wrong
see this,
1)suppose u given condition like sal=true ,the session will
successfully execute but no data load in to target.
2)suppose u given condition like sal='true' it's not
validated b'coz in filter true/false like 1/0.
3)suppose u given condition like onlt true ,the session will
successfully execute and all the data also loaded in to target.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a dimensional model?

571


what are factless facts? And in which scenario will you use such kinds of fact tables.

1299


Under what condition selecting sorted input in aggregator may fail the session?

653


What do you mean by filter transformation?

542


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1844






What is informatica powercenter repository?

699


Briefly describe lookup transformation?

590


What are the uses of etl tools?

630


How many number of sessions can one group in batches?

682


What is joiner transformation in informatica?

612


How can we create index after completion of load process?

587


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1467


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1541


Explain constraint based loading in informatica

646


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9154