Interested to Buy Any Domain ? << Click Here >> for more details...
we have 20 records in source system, when we run for the 1st
time, it should load only 10 records into the target, when
you run for the second time it should load another 10 record
which are not loaded. How do we do that? Can we write a SQL
query in source qualifier to do it. This q' is asked in one
f the interviews. Please let me know if anyone knows. Thanks
- 3 Answers
- 8210 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / suresh
SQ ==> select rownum as num,col1,col2,.. from table
FLT ==> num >= MVar1 and num <=MVar2
Mvar1 and MVar2 are assigned with the value of 1 and 10 respectively
in EXP=>V-port - setvariable(mvar1, 10)
V-port - setvariable(mvar1, 20)
after the execution of the mapping 10 and 20 values are stored in the mvar1 and mvar2 into the repository
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many number of sessions can one group in batches?
How to load the data from people soft hrm to people soft erm using informatica?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Explain transaction control transformation in informatica
What are mapplets? How is it different from a Reusable Transformation?
how many types of dimensions are available in informatica?
What are different types of transformations available in informatica?
What is joiner transformation in informatica?
What is dynamic cache?
Write the different tools in the workflow manager?
What is the scenario which compels informatica server to reject files?
How to elaborate tracing level?
What are the different components of powercenter?
Target increases every day even though no new record was inserted
What is mapplet in informatica?
