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
What is the sql query overwrite in source qualifier in informatica
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 ?
State the differences between sql override and lookup override?
Different circumstance which drives informatica server to expel records?
what is $$$$?
How many dimensions are there in informatica?
What does cheating measurement mean?
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
Explain the use of aggregator cache file?
permutations of mapplet
How we can use union transformation?
Quickly characterize reusable change?
what is SDLC way of code development?
Write the different tools in the workflow manager?
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.