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?
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 |
What are materialized views & where do we use them?
How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)
Difference between flat files and relational sources?
Explain what is etl process? How many steps etl contains explain with example?
What is data cleaning?
Explain about round-robi?
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?
Difference between flat files and relational sources?
What is etl tool in hadoop?
list and discuss two approaches for updation of target table in Informatica and how they are different.
what is the advantage of persistent cache? when it should be used?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?