Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4229 Views
- I also Faced
- E-Mail Answers
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
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.
How many steps etl contains explain with example?
if i have a query as flat file how can we load data to target table
how many maximum session supports to multiload in teradata ??
How to increase performance without changing anything in mapping.( In prod)
Explain etl mapping sheets?
Explain what is etl process? How many steps etl contains explain with example?
What is tracing level? How many types of transformations supported by sorted input?
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
What are the various tools used in etl?
list and discuss two approaches for updation of target table in Informatica and how they are different.
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
what is different between sequential batch and concurrent batch and which is recommended and why?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
what are the concerns of OLTP and DSS systems?
