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

what is song in infrmatica...?

1922


What is the status code in stored procedure transformation?

899


what is the complex transformation you used in informatica

2389


can anyone explain me about retail domain project in informatica?

7702


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1913


Name at least 5 different types of transformations used in mapping design and state the use of each.?

900


What do you mean by worklet?

830


What are the tuning techniques you applied during your last project

1788


What is the different lookup cache(s)?

813


How many ways are there to do 'remove duplicate records in informatica'?

779


What is event and what are the tasks related to it?

830


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1374


Explain lookup transformation is active in informatica

858


Differences between version 7.x and 8.x.

1640


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1851