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

how do u implement scheduling in Informatica?

1 Answers   Cognizant,


What is Relational Integrity?

1 Answers  


Two default user groups created in the repository are____and_____.

0 Answers  


What is data modeling and data mining?

0 Answers  


Difference between flat files and relational sources?

0 Answers  






when should one create lookup transformation ?

2 Answers  


What is etl process? How many steps etl contains?

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 cube grouping?

0 Answers  


what is a test load?

3 Answers  


you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.

3 Answers  


What is initial load and what is full load?

0 Answers  


Categories