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
- 30781 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
tell me about your project functionality
Reusable transformation and shortcut differences
In which transformation you cannot drag ports into it?
When do you use sql override in a lookup transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
what is the size of u r source(like file or table)?
Performance tuning( what you did in performance tuning)
What is the difference between informatica 7.0 and 8.0?
What are the settings that you use to configure the joiner transformation?
what is informatica metadata?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How can you define user defied event?
what is Active lock explain
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Why update strategy and union transformations are active? Explain with examples.
