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
- 34888 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
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What do you understand by SOA of Informatica?
What is the difference between Active and Passive transformation?
What is the sequence generator transformation in informatica?
What is dynamic cache?
Explain the shared cache and re-cache?
What is Data Caches size?
Can we get 1st record through Informatica(without sequence number).
What are the types of schemas we have in data warehouse and what are the difference between them?
What is source qualifier transformation in informatica?
What is parallel processing in informatica?
What are the tasks that can be performed using sq?
What is exclusive and normal mode for repository services?
What are the tuning techniques you applied during your last project
What does command task mean?
