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?
- 1 Answers
- 3779 Views
- I also Faced
- E-Mail Answers
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 |
how would u estimate the size of Aggregator transform data and index cache?
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.
How to delete data which is not in source table?
0 Answers IBM, Saama Tech, Wipro,
Can u access a repository created in previous version of Informatica?
What is a staging area? What is the purpose of a staging area?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000
What are cubes and olap cubes?
Need Informatica Power Center 9.1 free download(for all windows version)
Define slowly changing dimensions (SCD)?
What are the steps involved in etl process?
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
Teradata 
