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
- 34492 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
Is there any way to read the ms excel datas directly into informatica?
Reusable transformation and shortcut differences
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What will be the approach?
What is exclusive and normal mode for repository services?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are the tuning techniques you applied during your last project
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Explain sessions and how many types of sessions are there?
explain about unit testing? in real time?
What are the types of caches in lookup?
What is a predefined event?
What are some examples of informatica etl programs?
