Answer Posted / bobby

Transformation allow you to define transformation rules i.e.
business logic used for processing data.
There are 2 types of transformation they are:-
1.Active transformation
2.Passive transformation
1.Active transformation :- The number of rows which enter
the transformation is not same as number of rows exit the
transformation i.e chages occur.
2.Passive transformation :-The number of rows which enter
the transformation is same as number of rows exit the
transformation i.e chages does not occur.

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1078

---

Where can we find the throughput option in informatica?

1011

---

What is informatica metadata and where is it stored?

946

---

How you can differentiate between connected lookup and unconnected lookup?

1016

---

How to join three sources using joiner?

1043

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2278

---

Explain your project of banking domian.

1618

---

How do you promote a non-reusable transformation to reusable transformation?

1080

---

what is degenerated dimension?

3890

---

What is a passive transformation?

1049

---

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.

1954

---

Briefly describe lookup transformation?

994

---

What are the components of workflow manager?

1033

---

tell me about your project functionality

2309

---

What are the transformations that are not supported in mapplet?

971

---