If one flat file contains n number records., we have to load
in target from 51 to 100.. how to use expressions in
Informatica..?
Answer Posted / venkateshmalneni
Generate sequence by using sequence generator or by using expression t/r
connect the output to the filter t/r in filter write the condition as sno>=51 and sno=100
connect it to the target
src--->sq---> expression--->filter--->target
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to differentiate between the active and passive transformations?
Whats the difference between informatica powercenter server, repositoryserver and repository?
what is the complex transformation you used in informatica
Explain sessions and how many types of sessions are there?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is informatica metadata and where is it stored?
What are the different types of transformation available in informatica.
is it possible to index the data in cache of lkp transformation ?
how to load rows into fact table in data warehouse
How can a transformation be made reusable?
How many ways are there to do 'remove duplicate records in informatica'?
Explain how to import oracle sequence into informatica?
How do you load alternate records into different tables through mapping flow?
What is Session and Batches?
How to elaborate powercenter integration service?