Answer Posted / srikanth
select * from table where rownum<=30
minus
select * from table where rownum<=21;
Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
What are the different versions of informatica?
How to elaborate powercenter integration service?
What is informatica powercenter repository?
What is expression transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the different components of powercenter?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What are the different types of olap? Give an example?
what is informatica metadata?
What is session task and command task?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Suppose we do not group by on any ports of the aggregator what will be the output?
Define joiner transformation?
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
How can you define user defied event?