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
- 34518 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
explain abt ur project architecture?
What is a code page?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the sequence generator transformation in informatica?
What is a rank transform?
Differentiate between a repository server and a powerhouse?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are the types of lookup transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is meant by incremental aggregation?
What are the different types of transformation available in informatica.
wf dont have integration severances how you can run?
Explain joiner transformation in informatica
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is union transformation in informatica?
