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
- 33933 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / anoymous
override source qualifier
select * from tablename where rownum=1 and rownum=10;
| Is This Answer Correct ? | 4 Yes | 16 No |
Post New Answer View All Answers
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How to generate sequence numbers using expression transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
which one is better performance wise joiner or look up
How to create a non-reusable instance of reusable transformations?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is sequence generator transformation in informatica?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How to update or delete the rows in a target, which do not have key fields?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What are the static cache and dynamic cache in informatica?
What is the format of informatica objects in a repository?
How to Create a folder using pmrep command?
In how many ways we can create ports?
