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 / arvind s

Sorry guys, Answer 3 is completely wrong.

TRUE is not identified as a string by informatica, its
represented as a bit, just like a high or low, (1 or 0)
almost equivalent to a boolean.

So we can equate sal=TRUE but sal='TRUE' will result in
invalid mapping as said in answer3.

Thanks,
Arvind S

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

1748


Global and Local shortcuts. Advantages.

1472


What is domain and gateway node?

700


What are the components of Informatica? And what is the purpose of each?

624


Different sorts of metadata that stores in the storage facility?

564






What is the sequence generator transformation in informatica?

616


Write the program through which the records can be updated?

520


What is lookup change?

624


Explain transaction control transformation in informatica

763


What is a pre-defined event and user-defined event?

581


Suppose we do not group by on any ports of the aggregator what will be the output?

582


What is data transformation manager process?

624


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

679


What is the use of an aggregator cache file?

693


Which version configuration tool used in ur project?

2771