What are the mapping paramaters and mapping variables?
Answer / swetha
Maping parameter represents a constant value that yoU can
define before running a session. A mapping parameter retains
the same value throughout the entire session. When you use
the maping parameter , yoU declare and use the parameter in
a maping or maplet. Then define the value of parameter in a
parameter file for the session. Unlike a mapping parameter,
a maping variable represents a value that can change
throughout the session. The informatica server saves the
value of maping variable to the repository at the end of
session run and uses that value next time yoU run the session.
| Is This Answer Correct ? | 3 Yes | 0 No |
In a sequential batch can you run the session if previous session fails?
What is parameter file?
What is the need of an ETL tool?
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks
how u know when to use a static cache and dynamic cache in lookup transformation.
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
r u done any partitions in ur project?
Explain how to import oracle sequence into informatica?
Where can we find the throughput option in informatica?
What is the difference between Bulk Load and Normal Load
What is the benefit of partitioning a session?