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 / sathish
source may be flat file or database just you use sequence ganarater then filter copy the nextval port to filter write condition nextval=1 or nextval=10 you get only 1 and 10 th records
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can a transformation be made reusable?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is the use of transformation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
list out all the transformations which use cache?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
permutations of mapplet
What is the way to execute pl/sql script using informatica mapping?
Define mapplet?
Explain what are the different types of transformation available in informatica.
What are the steps involved in the migration from older version to newer version of Informatica Server?
In warehouses how many schemas are there?
How many dimensions are there in informatica?