Answer Posted / chaitanya

An interesting use for a junk dimension is to capture the context of a specific transaction. While our
common, conformed dimensions contain the key dimensional attributes of interest, there are likely
attributes about the transaction that are not known until the transaction is processed.

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

1148

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1953

---

What is the sequence generator transformation in informatica?

1184

---

Where do we use mapping variables in informatica?

1065

---

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

1796

---

What is the difference between router and filter?

1269

---

What is standalone command task?

1315

---

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.

1995

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2169

---

Explain load alternative records / rows into multiple targets - informatica

1152

---

What is parallel processing in informatica?

1714

---

What is update strategy transform?

1102

---

what is the -ve test case in your project.

2407

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1016

---

What are the different clients of powercenter?

1060

---