Answer Posted / sanjay

Except to previous points.........

1. PMCMD: By using this option we can use parameter file at
command prompt. Why this needed suppose we are using more
than on parameter file, in such case we have to change the
parameter file in session properties. By this option u can
run from command prompt by changing parameter file, no need
to go to session properties.

2. Test load: we can test the load by taking the specified
no. of records.

What all are steps in up gradation of Informatica server?

1033

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2396

---

What is a snowflake schema?

978

---

How do you load only null records into target? Explain through mapping flow.

1999

---

What is olap (on-line analytical processing?

1055

---

Enlist the tasks for which source qualifier transformation is used.

1022

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1219

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1774

---

How to create a non-reusable instance of reusable transformations?

1098

---

What is meant by active and passive transformation?

1111

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1911

---

What is the function of look up transformation?

1109

---

Enterprise data warehouse your projects phase by phase explain?

1907

---

Different circumstance which drives informatica server to expel records?

963

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1160

---