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
where we cannot use sorter Transformation. if we use then we will not get correct data?
how do u extract data from different data sources explain with an example?
Mention few test cases and explain them?
Explain do we need an etl tool?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
Define Dynamic push down optmization?
Explain different types of partitioning?
Can u access a repository created in previous version of Informatica?
Is hadoop a etl tool?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
what is the difference between cardinality and Nullability?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
What is etl tool in hadoop?
what are the facilities provided by data warehouse to analytical users?
What are three tier systems in etl?