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
- 8280 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
What are the types of caches in lookup?
What is the scenario which compels informatica server to reject files?
What does role playing dimension mean?
What are the different types of transformation available in informatica.
How to convert multiple rows to single row (multiple columns) in informatica
What is rank index in rank transformation?
How to load data in informatica ?
Which transformation is needed while using the Cobol sources as source definitions?
difference between repository database and repository service?
How can we remove the duplicates from flat file source?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are different types of transformations available in informatica?
How to start a workflow using pmcmd command?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
