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
What is olap (on-line analytical processing?
without table how to come first record only in oracle?
What is a grid in Informatica?
What are the prerequisite tasks to achieve the session partition?
whats the logic to load the lower level of granularity of data to fact table.
Can we override a native sql query within informatica?
What is meant by active and passive transformation?
Explain the code page compatibility?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is a sorter transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
How we can create indexes after completing the loan process?
What are the types of caches in lookup? Explain them.
Define filter transformation?
How to Create a folder using pmrep command?