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
Differentiate between router and filter transformation?
Difference between Target-based loading and constraint-based loading?
How can you define user defied event?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is a sequence generator transformation?
How can we handle two sessions in informatica?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
my source is junk data how will u remove that junk data by using unix please any one replay me
What's the layout of parameter file (what does a parameter file contain?)?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the differences between oltp and olap?