what is a parameter when and where do u them when does the
value will be created. Designing time, run time. If u don't
create parameter what will happen?
Answer Posted / murthy
oh such a big question!
parameter withn values are generally created in a notepad
in the specified location.IN the mapping go to designer--
>mappingparameters/variables->u set the parameters there .
coming to the usage in realtime what we do is we will
create the source and target connection information in the
parameter files.
one simple example to make u understand it's use is
let's take dollar and rupee relation.dollar value is not
conatant everday it will change ,so u can't change u r
mapping every day,hence what u will do is u will create the
mapping as per the requirement but u will save the dollar
value in the parameter file .so if u want to change it's
value u will change the parameter file not the mapping.
if u didn't get let me knoe i will answer again.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
when will use SQL override in a lookup transformation?
what is an ETL or ETT? And what are the different types?
What are various etl tools in the market?
What is grain of fact?
How many types of transformations supported by sorted input?
what is Forward,Reverse and Re_engineering?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What are the three tiers in etl?
what are the data modeling tools you have used?(polaris)
explain the methodology of Data Warehousing?(Polaries)
What is tracing level?
What are the names of the layers in etl?
When do we analyze the tables? How do we do it?
how do u implement configuration management in Informatica?
What are the types of Data Warehouse applications?