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
- 8259 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 validations that you can perform in oracle and in informatica ? Advance Thanks
How to create a non-reusable instance of reusable transformations?
Describe the impact of several join conditions and join order in a joiner transformation?
Please let me know how to make Data masking in informatica..
What are the main features of Oracle 8i with context to datawarehouse?
Briefly define a session task?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Design a mapping to load a target table with the following values from the above source?
Enlist some properties of sessions.
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How many ways a relational source definition can be updated and what are they?
What do you mean by filter transformation?
Can u generate reports in Informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
