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
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
draw informatica architecture 8.6 ?
Enlist the differences between database and data warehouse.
What is a predefined event?
Explain lookup transformation is active in informatica
Enlist the tasks for which source qualifier transformation is used.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Explain the scenario which compels informatica server to reject files?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Enlist the various types of transformations.
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
what are the deliverables?in your project?
Explain what are the different versions of informatica?
What is lookup transformation?
What is pmcmd command?