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
- 8209 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / babu
Hi,
If u r source is Relational,then u can write sqloverride.
i.e
SQ ==> select rownum as num,col1,col2,.. from table
FLT ==> (num >= MVar1 and num <=MVar2)
NOTE: MVar1,MVar2 are mapping variables the initial values
of these variables 1,10 with respectivelly.
after completion of firsst run the variables are increased
11,20 respectivelly.all are knows how to declare the
mapping variables.
IF THERE IS ANY WRONG PLEASE CORRECT ME.
Thanks,
Babu
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What are the modules in Power Center
what is the -ve test case in your project.
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Partition, what happens if the specified key range is shorter and longer
What are the informatica performance improvement tips
What do you mean by blocking transformation?
To import the flat file definition into the designer where should the flat file be placed?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
what is SDLC way of code development?
What is the difference between router and filter?
What does role playing dimension mean?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Explain load alternative records / rows into multiple targets - informatica
What are data-driven sessions?
