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
- 33928 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
Why filter transformation is an active one?
Explain the different lookup methods used in informatica?
How many ways are there to do 'remove duplicate records in informatica'?
What is mapping debugger?
What are the different clients of powercenter?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is data transformation manager process?
How you prepared reports for OLAP?
How can we improve session performance in aggregator transformation?
What are the reusable transformations?
How can repository reports be accessed without sql or other transformations?
Define update strategy?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
what is unit testing?tell me proceedure
