Answer / Shah Harsh Satishkumar

The Source Qualifier transformation in Informatica is used to qualify the data coming from a source by specifying the conditions or rules to filter, sort, aggregate, or rearrange the data. This transformation helps to clean and prepare the data before it is transformed or loaded into the target.

insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  

---

How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,

---

What is mapping debugger?

1 Answers  

---

What is session task and command task?

1 Answers  

---

What is informatica powercenter repository?

1 Answers  

---

What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1 Answers   TCS,

---

From where we can start or use pmcmd?

3 Answers  

---

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

---

what are the types of facts with Examples?

3 Answers  

---

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1 Answers  

---