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 are the differences between source qualifier and joiner transformation?

602


What does refresh system mean, and what are its distinctive choice?

568


What is aggregator transformation in informatica?

545


Tell me about Propagate functions in informatica

528


How can informatica be used for an organization?

653






Clarify the aggregator change?

598


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2142


What is data caches/ index caches?

617


how many types of dimensions are available in informatica?

565


What is enterprise data warehousing?

616


Quickly characterize reusable change?

693


Explain pushdown optimization and types in informatica

672


What are the limitations of joiner transformation?

657


How to generate or load values in to the target table based on a column value using informatica etl tool.

614


How to extract sap data using informatica?

607