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
- 34519 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
Can we create a Integration service without a Repository service and vice versa?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is the commit type if you have a transaction control transformation in the mapping?
How does the aggregator transformation handle null values?
What is the Process to creating lookup transformation in informatica
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Where can we find the throughput option in informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Define enterprise data warehousing?
Difference between Data and Index Caches?
How many dimensions are there in informatica?
What does refresh system mean, and what are its distinctive choice?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How to call shell scripts from informatica?
How to extract the informatica rejected data?
