Answer / maruthi

1.)use to_integer('column name','newcolumn)
it works

Which are the different editions of informatica powercenter that are available?

0 Answers  

---

what is data driven in update strategy transformation?

2 Answers   HCL, PayPal,

---

why do u use shortcuts in informatica.?

4 Answers   iFlex,

---

Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

3 Answers   Amdocs,

---

Can we use the mapping parameters or variables created in one mapping into another mapping?

1 Answers   Informatica,

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

0 Answers  

---

How many cubes create from a single model?

1 Answers  

---

What are the types of maping in Getting Started Wizard?

1 Answers  

---

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,

---

Mention a few design and development best practices for informatica?

0 Answers  

---

Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,

---

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

---