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 SDLC way of code development?
What are the components of Informatica? And what is the purpose of each?
Explain the shared cache and re-cache?
What is data caches/ index caches?
What is union transformation in informatica?
Different circumstance which drives informatica server to expel records?
Where is metadata stored?
Explain the types of lookup transformation?
How do you load first and last records into target table?
What are data-driven sessions?
What is sq transformation?
What is the difference between router and filter?
What is olap (on-line analytical processing?
What is informatica metadata and where is it stored?
can any one give some examples for pre sql and post sql(Except dropping and creating index).