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
- 34473 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
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Where is metadata stored?
What is the use of transformation?
Is stop and abort are same in informatica?
expain about the tune parameters?
What is a code page?
What is depict expression change?
generate date / time dimension in informatica
Implementation methodology
What are the transformations that are not supported in mapplet?
What do you understand by term role-playing dimension?
what is unit testing?tell me proceedure
Differentiate between Load Manager and DTM?
What is a snowflake schema?
Tell me about Propagate functions in informatica
