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
how to load the data to fact table?
What is Data Vault???
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
Can we create Hierarchies in generic datasources?
How to increase performance without changing anything in mapping.( In prod)
What are cubes and olap cubes?
When do we analyze the tables?
What are the modules in Power Mart?
how do u set partition points in the mapping?
what is pmrep command?
What are three tier systems in etl?
Give the benefits of data integration suite?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
what is Forward,Reverse and Re_engineering?