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
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
what are the facilities provided by data warehouse to analytical users?
What is a materialized view log?
explain the methodology of Data Warehousing?(Polaries)
What is grain of fact?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
explain the methodology of Data Warehousing?(Polaries)
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
what is Forward,Reverse and Re_engineering?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
Define slowly changing dimensions (SCD)?
how to load the data to fact table?
what is dynamic insert?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?