If one flat file contains n number records., we have to load
in target from 51 to 100.. how to use expressions in
Informatica..?

Answer Posted / hari

create mapping like

source -- sorter -- expression -- filter -- target.

here sorter is used to send data by ascending order data
this is not mandatory.

Expression is need to create variable port which will count
the rows which are comming in.

Filter having condition like if count value >=51 and count
value <= 100.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the sql query overwrite in source qualifier in informatica

595


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6013


State the differences between sql override and lookup override?

594


Different circumstance which drives informatica server to expel records?

531


what is $$$$?

1709






How many dimensions are there in informatica?

596


What does cheating measurement mean?

572


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1563


Explain the use of aggregator cache file?

646


permutations of mapplet

2013


How we can use union transformation?

581


Quickly characterize reusable change?

658


what is SDLC way of code development?

1536


Write the different tools in the workflow manager?

548


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

752