Answer Posted / deepthi

Here the question is to just display value 'MR'for
males 'MR'for males , not to modify the data in the table
as 'MR'for males 'MR'for males

we can do it by many ways, one among those ........

select decode(column_name, 'male','MR','female','MRS')

this query displays MR for all males and MRS for all females

Please let me know how to make Data masking in informatica..

1699

---

What is the status code in stored procedure transformation?

1168

---

Differentiate between joiner and lookup transformation?

1094

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2378

---

what are 3 tech challenges/ common issues you face?

2332

---

Please let me know how to make encryption and decryption with example?

1886

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1941

---

What is exclusive and normal mode for repository services?

1125

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1111

---

design of staging area?

2016

---

How can a transformation be made reusable?

1145

---

What are the main issues while working with flat files as source and as targets ?

1141

---

What is aggregator transformation in informatica?

925

---

What are mapplets?

1254

---

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

1936

---