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
What is the surrogate key?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How to use pmcmd utility command?
What is a pre-defined event and user-defined event?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How to load last n records of file into target table - informatica
What is session task and command task?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Can we create two repositories on same database instance in oracle?
Which are the different editions of informatica powercenter that are available?
What is a router transformation?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is a filter transformation and why it is an active one?
In informatica workflow manager, how many repositories can be created?