Interested to Buy Any Domain ? << Click Here >> for more details...
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
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is a passive transformation?
difference between informatica 8.1.1 and 8.6
tell me about your project functionality
What is the meaning of decode in informatica?
What is fact table? Explain the different kinds of facts.
What are connected or unconnected transformations?
What is a repository? And how to add it in an informatica client?
What is deployment group?
What are multi-group transformations?
Describe data concatenation?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is aggregator transformation in informatica?
What is the maplet?
What are the tasks that source qualifier perform?
