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

How many types of sessions are there in informatica.please explain them?

677


What is meant by incremental aggregation?

579


Enlist the various types of transformations.

554


Define mapping and session?

583


How big was your fact table

1313






What is the procedure for creating independent data marts from informatica 7.1?

563


Define pmcmd command?

618


What are the differences between a connected lookup and unconnected lookup?

644


How would you copy the content of one repository to another repository?

550


Tell me about Propagate functions in informatica

521


What is dynamic cache?

610


What are the guidelines to be followed while using union transformation?

636


How to open an older version of an object in the workspace?

615


What is session task and command task?

646


can we override a native sql query within informatica? Where do we do it?

621