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?
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 |
What is etl process? How many steps etl contains?
What are the various tools used in etl?
Explain the difference between etl tool and olap tools?
Can there be sub steps of etl steps?
How etl testing is different from database testing?
What is a lookup table in etl?
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??
list and discuss two approaches for updation of target table in Informatica and how they are different.
What is ROWID explain ?
Identifying the bottlenecks in various components of Informatica and resolving them.
When do we analyze the tables? How do we do it?
Need Informatica Power Center 9.1 free download(for all windows version)