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
- 33924 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / eswar
As Prakash said
ower write sq ("select *from <tableNmae> where rownum <=
10;")
Instead of using Aggregator its better if we use Router
Transformation, wherefrom we can route the rows to target
(s).
note: use two target table in which u want to load that two
records
====
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Make a note of the quantity vaults made in informatica?
Mention few advantages of router transformation over filter transformation.
What are the different lookup cache(s)?
How to join three sources using joiner? Explain though mapping flow.
How are indexes created after completing the load process?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Is it possible to revert a global repository to local one and why?
What is meant by target load plan?
Design a mapping to load the cumulative sum of salaries of employees into target table?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Explain why we use partitioning the session in informatica?
What is complex mapping?
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 ?
What is a joiner transformation?
Differentiate between Load Manager and DTM?
