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
- 8262 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
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 many ways are there to do 'remove duplicate records in informatica'?
Implementation methodology
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is powercenter on grid?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
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?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is meant by LDAP users?
What do you mean by enterprise data warehousing?
Global and Local shortcuts. Advantages.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How to partition the Session?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Different sorts of metadata that stores in the storage facility?
