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 / chakri

Use count variable

Use Variable port

Expression transformation

(Count>50) and (count<100)

Please let me know any information

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Reusable transformation and shortcut differences

1606


Why union transformation is an active transformation?

860


What is olap (on-line analytical processing?

849


What do you mean by enterprise data warehousing?

836


Where are the source flat files kept before running the session?

853


Describe an informatica powercenter?

823


To import the flat file definition into the designer where should the flat file be placed?

863


Explain about Informatica server process that how it works relates to mapping variables?

841


What is Data Caches size?

850


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

799


How do you manage the Parameter files while migrating your data from one environment to another environment?

788


Describe the impact of several join conditions and join order in a joiner transformation?

854


While migrating the data from one environment to another environment how would you manage the connections?

896


What are the types of caches in lookup?

796


What are the measure objects?

917