Answer / rkumar.etl

Unit testing in Informatica performed using ...

1)src qualifier query if providing us the final result
..with only calculating logic in between than ...test the
count results in sql navigator.

2)column to column mapping to make sure the result passing
to columns are correct.

3)data type mismatch or matched.

What are the connected or unconnected transforamations?

2 Answers  

---

why u go for dimensions ?

3 Answers   TCS,

---

What is the function of aggregator transformation?

0 Answers  

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

0 Answers   Informatica,

---

. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null

3 Answers  

---

Mention some types of transformation?

0 Answers  

---

How we can create indexes after completing the loan process?

0 Answers  

---

What are slowly changing dimensions?

5 Answers   Informatica, Verinon Technology Solutions,

---

Describe expression transformation?

0 Answers  

---

How to create Target definition for flat files?

0 Answers   Informatica,

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,

---

To provide support for Mainframes source data,which files r used as a COBOL files

1 Answers  

---