Answer / mike

A parameter file can be a text file. Parameter file is to
define the values for parameters and variables used in a
session. A parameter file is a file created by text editor
such as word pad or notepad. U can define the following
values in parameter file
Mapping parameters
Mapping variables
session parameters

hope this helps

How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,

---

how do u tune queries?

1 Answers  

---

why u go for dimensions ?

3 Answers   TCS,

---

Explain pushdown optimization and types in informatica

0 Answers   Informatica,

---

What is rank transform?

0 Answers  

---

---

What is substr in informatica?

0 Answers  

---

What is update override?

1 Answers   Accenture,

---

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  

---

in which situations do u go for snowflake schema ?

2 Answers   TCS,

---

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

---

What is the fact table?

0 Answers  

---

how do u move the code from development to production?

6 Answers  

---