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
- 8398 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 is meant by active and passive transformation?
Briefly define a session task?
Why sorter is an active transformation?
Can we create a Integration service without a Repository service and vice versa?
Explain what is informatica metadata and where is it stored?
Is it possible to define a single node as a Gateway node as well as worker node?
How to open an older version of an object in the workspace?
What are the components of the workflow manager?
What is joiner change?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What could be the possible resons of locks by user?
Whats there in global repository
Explain what are the different types of transformation available in informatica.
