Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / gopal
$$ - is used for Parameter...see the below example
select a,b,c from <table> where <table>.date-$$date_filter
when you define parameter file in the src File directory
and this should be given in session, if in parameter file
if you give 10, then above query will be as below
select a,b,c from <table> where <table>.date-10
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is workflow? What are the components of the workflow manager?
How do you load only null records into target? Explain through mapping flow.
How can we remove the duplicates from flat file source?
On which transformations you created partitions in your project?
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 ?
Separate from an archive server and a powerhouse?
What is rank transformation?
Can we create two repositories on same database instance in oracle?
Which is the t/r that builts only single cache memory?
how to load dimension table and fact table. plz tell me the steps.
What is the difference between source qualifier transformations source filter to filter transformation?
What are the different clients of powercenter?
How can you increase the performance in joiner transformation?
Explain the different lookup methods used in informatica?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
