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

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6008


Which means the first record should come as last record and last record should come as first record and load into the target file?

833


Can you use flat files in Mapplets.

2422


where to store informatica rejected data?

855


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

846


what is the size ur source like(file system or database)? how many record daily come u r banking project?

1938


Define mapplet?

807


explain abt ur project architecture?

1933


What is a passive transformation?

827


How to Create a folder using pmrep command?

843


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8031


Describe an informatica powercenter?

814


What is a connected transformation?

881


How many ways are there to create ports?

962


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1042