Answer Posted / shankar

source qualifier > expression <for best practice> > aggregator > normalizer . target.

here in this the SQ will be for relational & flat files, then we use expression for best practice, in this we take the ports which we need into target also we can rename the ports for our convenience just to avoid confusion.

Then for calculating totals we use aggregator.

to convert the rows to col we use the normalizer. This is to my knowledge. Thank you if wrong pls post.

How can we update a record in the target table without using update strategy?

1087

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2097

---

What is the different lookup cache(s)?

1034

---

Slowly changing dimensions, types and where will you use them

1653

---

What is a dimensional model?

926

---

What are ETL Tools?

1039

---

Briefly define a session task?

1053

---

Implementation methodology

1654

---

What is the difference between informatics 7x and 8x and what is latest version?

1022

---

What is a difference between complete, stop and abort?

1031

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2468

---

How can you differentiate between powercenter and power map?

1018

---

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.

1941

---

Why is sorter an active transformation?

1058

---

What are the modules in Power Center

1621

---