If one flat file contains n number of records., we have to
load the records in target from 51 to 100.. how to use
expressions in Informatica..?

Answer Posted / reena

use sequence generator to get row no. for each record ,then
use filter giving the condition (row no.greater than 50 and
less than 100)

Is This Answer Correct ?    14 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rank index in rank transformation?

830


r u done any partitions in ur project?

1598


What are the mapping parameters and mapping variables?

852


Name the different lookup cache(s)?

949


What does command task mean?

842


What are the uses of etl tools?

892


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1717


Can u generate reports in Informatica?

862


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

845


What is a mapplet/worklet in informatica?

951


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1862


Which are the different editions of informatica powercenter that are available?

828


Can we create multiple integration service on single repository?

978


Explain joiner transformation in informatica

912


What is meant by pre and post session shell command?

887