in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
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 happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
If informatica has its scheduler why using third party scheduler?
How can we use mapping variables in informatica? Where do we use them?
What are the components of the workflow manager?
Why filter transformation is an active one?
What is parallel processing in informatica?
tell me 5 session failure in real time how can you solve that in your project?
How can we use batches?
What are mapplets?
Write the advantages of partitioning a session?
Which is the t/r that builts only single cache memory?
How to join three sources using joiner? Explain though mapping flow.
EXL informatica Questions
What is mapping debugger?