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 / pradeepa
Hi,
If the comparing column is a varchar and if this true is
given in single quotes it will validate ,but here salary
for sure it must be a number and when we say salary=true it
will trow error,that expression wont be validated..
obviously mapping will get invalidated..so we cant evn run
the ,mapping.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the Rank index port in Rank transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
Why do you use Mapping Parameter and mapping variable?
Enterprise data warehouse your projects phase by phase explain?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is the use of transformation?
How do you load alternate records into different tables through mapping flow?
Do you find any difficulty while working with flat files as source and target?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Differentiate between sessions and batches?
Explain the types of transformations?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Describe expression transformation?
How many numbers of sessions can one group in batches?
Separate from a database, an information bazaar, and an information stockroom?