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 / venkateshmalneni
Generate sequence by using sequence generator or by using expression t/r
connect the output to the filter t/r in filter write the condition as sno>=51 and sno=100
connect it to the target
src--->sq---> expression--->filter--->target
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is meant by pre and post session shell command?
how to load dimension table and fact table. plz tell me the steps.
What is main use of mapplet?
Briefly define a session task?
What are the new features of informatica 9.x developer?
How can we improve session performance in aggregator transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
Explain about cumulative Sum or moving sum?
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.
How to use procedural logic inside infromatica?
can anyone explain me about retail domain project in informatica?
What is rank transformation in informatica
What is meant by a domain?
How to create Target definition for flat files?
What is meant by incremental aggregation?