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?



what is a parameter when and where do u them when does the value will be created. Designing time, r..

Answer / 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

More ETL Interview Questions

Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com

320 Answers   Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,


how would u estimate the size of Aggregator transform data and index cache?

0 Answers  


where is the cache (lookup, index) created and how can you see it.

0 Answers  


What is Data Vault???

0 Answers  


Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?

2 Answers  






Explain different types of partitioning?

0 Answers  


architural difference between 7.1 workflow monitor and 8.1 workflow monitor.

1 Answers   IBM, Infosys,


Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

0 Answers   Cap Gemini,


What are the different ways to deploy the code in informatica?

1 Answers   IBM, Saama Tech, Wipro,


Explain what is etl process? How many steps etl contains explain with example?

0 Answers  


Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

0 Answers  


What is a mapping, session, worklet, workflow, mapplet?

0 Answers  


Categories