If a table contains 100 records we have to fetch 50-100
records from source to target?how
Answer Posted / imran
use a Sequence Generator T/R........
GO to SG T/r-->Properties (Set the values as shown below)--->
1) 'Enable' the Cycle Option
2) give 'Start value' as 50
3)End Vale 100
4) Increment BY 1
5) Connect Nextval & Currval o/p ports to Target
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
How might you approve all mappings in the archive all the while?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are mapplets?
How to do unit testing in informatica?
Describe data concatenation?
What is event and what are the tasks related to it?
How many ways are there to do 'remove duplicate records in informatica'?
How does a rank transform differ from aggregator transform functions max and min?
What is mapping debugger?
What are the new features of Power Center 5.0?
What is domain in terms of informatica?
Explain target update override in informatica
In warehouses how many schemas are there?
Explain the types of lookup transformation?
Write the unconnected lookup syntax?