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
Is there any way to read the ms excel datas directly into informatica?
how to load dimension table and fact table. plz tell me the steps.
What all are steps in up gradation of Informatica server?
What is enterprise data warehousing?
waht type of interface is used for testing the data in informatica
What are the guidelines to be followed while using union transformation?
Explain how many types of dimensions are available in informatica?
Define sessions in informatica etl?
What is a dimensional model?
How can we update a record in the target table without using update strategy?
What are the different types of repositories created using informatica?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How to load data in informatica ?
State the limitations where we cannot use joiner in the mapping pipeline?
What are the tuning techniques you applied during your last project