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

Yes. For better performance filter the records using Unix's
Head,Tail commands. Pass the particular records to SQ and
Load.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is source qualifier transformation in informatica?

571


Repository user profiles

1373


What is a snowflake schema?

565


What is the difference between stop and abort in informatica

658


What are the restrictions of union transformation?

576






Which is the t/r that builts only single cache memory?

707


What are session parameters ? How do you set them?

1375


How to handle decimal places while importing a flatfile into informatica?

716


What is the different lookup cache(s)?

610


How you know when to use a static cache and dynamic cache in lookup transformation?

1334


What is a joiner transformation?

550


When do you use sql override in a lookup transformation?

583


Explain where to store informatica rejected data? How to extract the informatica rejected data?

575


What are the new features of informatica 9.x developer?

530


what is informatica metadata?

597