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.

where we cannot use sorter Transformation. if we use then we will not get correct data?

2244

---

What are the modules in Power Mart?

1018

---

What is lookup table in etl testing?

1230

---

What are the different etl testing categories as per their function?

1140

---

what are the session parameters? How do u set them?

2090

---

Is apache nifi an etl tool?

1014

---

Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

3077

---

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?

2936

---

what is dynamic insert?

2249

---

Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

2279

---

what is the meant by Normalization and de-normalization?

2763

---

What are three tier systems in etl?

1121

---

Explain the use lookup tables and Aggregate tables?

1021

---

what are the concerns of OLTP and DSS systems?

1999

---

what are Lookup caches options? Including persistent caches.

2022

---