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

What is etl process? How many steps etl contains?

0 Answers  


What are the various tools used in etl?

0 Answers  


Explain the difference between etl tool and olap tools?

0 Answers  


Can there be sub steps of etl steps?

0 Answers  


How etl testing is different from database testing?

0 Answers  


What is a lookup table in etl?

0 Answers  


we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??

1 Answers  


list and discuss two approaches for updation of target table in Informatica and how they are different.

0 Answers  


What is ROWID explain ?

2 Answers   Wipro,


Identifying the bottlenecks in various components of Informatica and resolving them.

2 Answers  


When do we analyze the tables? How do we do it?

0 Answers  


Need Informatica Power Center 9.1 free download(for all windows version)

1 Answers   ABC,


Categories