Interested to Buy Any Domain ? << Click Here >> for more details...
in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
- 11 Answers
- 33931 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / chandra
override source qualifier
SELECT E.* FROM(SELECT ENAME,SAL,ROWNUM R FROM EMP) E WHERE
R IN (1,5);
HERE I TAKE EMP TABLE
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Differences between version 7.x and 8.x.
what is the -ve test case in your project.
On which transformations you created partitions in your project?
What is repository manager?
what is informatica metadata?
How many ways are there to create ports?
whats the logic to load the lower level of granularity of data to fact table.
How to delete duplicate row using informatica?
Is it possible to revert a global repository to local one and why?
What is the reusable transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Mention some types of transformation?
Explain the features of connected and unconnected lookup.
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 you prepared reports for OLAP?
