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
What is the function of union transformation?
What are the components of workflow manager?
What all join we can perform in LOOKUP transformation?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How do you migrate data from one environment to another?
How do you load alternate records into different tables through mapping flow?
generate date / time dimension in informatica
What is a difference between complete, stop and abort?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the different lookup cache(s)?
How can we use batches?
What is decode in informatica?
Enlist few areas or real-time situations where informatica is required.