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
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
What is the difference between Data Warehousing and Data Mining?
What is grain of fact?
What is a materialized view log?
What is staging area referring to?
What are the differences between sql override and update override?
Explain what is etl process? How many steps etl contains explain with example?
How etl testing is different from database testing?
State the differences between shortcut and reusable transformation
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.
Identifying the bottlenecks in various components of Informatica and resolving them.
what do u do when DB time takes more?in sap bi
What are the various tools used in etl?
if i have a query as flat file how can we load data to target table
What are the etl testing operations includes?