If one flat file contains n number records., we have to load
in target from 51 to 100.. how to use expressions in
Informatica..?
- 2 Answers
- 5749 Views
- I also Faced
- E-Mail Answers
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
Explain the scenario which compels informatica server to reject files?
Is there any way to read the ms excel datas directly into informatica?
What is primary and backup node?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Different circumstance which drives informatica server to expel records?
Have you worked with/created Parameter file
What happens when a session fails and you click on recover?
What is enterprise data warehousing?
Enlist the various types of transformations.
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What are the different options available for update strategy?
What is main use of mapplet?
How do you load unique records into one target table and duplicate records into a different target table?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How to convert multiple rows to single row (multiple columns) in informatica
