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
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What happens when a session fails and you click on recover?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
how tokens will generate?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is an Integration service in Informatica?
Suppose we do not group by on any ports of the aggregator what will be the output?
How we can create indexes after completing the loan process?
Write the unconnected lookup syntax?
How to partition the Session?
Tell me about Propagate functions in informatica
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How might one distinguish in the case of mapping is right or not without associating session?
what is the size of u r source(like file or table)?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?