Answer Posted / rakesh

Node is a physical entity under Domain which is a logical
entity. Just like a team member(physical) in a team(logical).
We can create number of nodes under a domain, One MASTER
NODE and number of CHILD NODES.
In Master Node we create Repository service.

Differentiate between reusable transformation and mapplet.

1047

---

How does a rank transform differ from aggregator transform functions max and min?

1165

---

State the differences between sql override and lookup override?

1139

---

How can repository reports be accessed without sql or other transformations?

1175

---

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1957

---

What do you understand by term role-playing dimension?

1005

---

What is an expression transformation in informatica?

978

---

What are the differences between a connected lookup and unconnected lookup?

1027

---

Explain what are the different versions of informatica?

1053

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1595

---

What is a stored procedure transformation?

1008

---

How do you use reject loader.

2560

---

Explain sessions. Explain how batches are used to combine executions?

969

---

What is a connected transformation?

1066

---

Explain the features of connected and unconnected lookup.

893

---