Interested to Buy Any Domain ? << Click Here >> for more details...
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
1197Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
1200Post New Informatica Questions
Define joiner transformation?
What is the maplet?
What is source qualifier transformation in informatica?
What is option by which we can run all the sessions in a batch simultaneously?
What is the Rank index port in Rank transformation?
What are the differences between a connected lookup and unconnected lookup?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What are the different types of olap? Give an example?
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 does update strategy mean, and what are the different option of it?
What are the static cache and dynamic cache in informatica?
Explain scd type 3 through mapping.
without table how to come first record only in oracle?
Reusable transformation and shortcut differences
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
