Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / c manojkumar

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

What is an active transformation?

0 Answers   Informatica,

&#61656; Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,

I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  

What is olap (on-line analytical processing?

0 Answers  

In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

1 Answers   TCS,

Differentiate between source qualifier and filter transformation?

0 Answers  

what is inline view?

1 Answers   IBM,

What is confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

0 Answers  

difference between informatica 8.1.1 and 8.6

0 Answers   TCS,

what is incremental loading ?

12 Answers   CTS, IBM, Oracle, TCS,

what is session override?

2 Answers   Cap Gemini,

For more Informatica Interview Questions Click Here
Categories