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 are the uses of etl tools?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is the sequence generator transformation in informatica?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Define pmcmd command?
What are active and passive transformations?
What is a repository? And how to add it in an informatica client?
Differentiate between router and filter transformation?
What is the Process to creating lookup transformation in informatica
What is informatica?
Write the unconnected lookup syntax and how to return more than one column.
What is event and what are the tasks related to it?
What do you understand by SOA of Informatica?
What is the procedure for creating independent data marts from informatica 7.1?
How we can use union transformation?