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
- 34886 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / prakash kumar kumhar
ower write sq ("select *from <tableNmae> where rownum <= 10;")
than use two aggregation transformation (in first use first(),and in second use last() for each column)from sq to target.
note: use two target table in which u want to load that two records.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are mapplets?
What are the tasks that can be performed using sq?
Is it possible to define a single node as a Gateway node as well as worker node?
How to start a workflow using pmcmd command?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the features of complex mapping?
Performance tuning in UNIX for informatica mappings?
What are the modules in Power Center
Why do we need informatica?
Describe expression transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is a joiner transformation and why it is an active one?
What is domain in terms of informatica?
