Answer Posted / moorthy g
Source --->SQ ----> Expression ---> Target
===> Create Mapping Variable
===> In SQ use sql override
where startdate < $$date
====> In expression use variable port,
setmaxvariable($$date, startdate)
=====================================
You can find variable value in Log fine and session RC you
can find it.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can we create two repositories on same database instance in oracle?
What is the sql query overwrite in source qualifier in informatica
Why sorter is an active transformation?
If informatica has its scheduler why using third party scheduler?
How we can create indexes after completing the load process?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are active and passive transformations?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is informatica etl tool?
Explain the different kinds of facts.
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are the limitations of joiner transformation?
Difference between Data and Index Caches?
What is meant by incremental aggregation?
How to Create a folder using pmrep command?