Answer Posted / chiky

if its in oracle database,use

select id, name, (SELECT TO_CHAR (TO_DATE sal, 'j'), 'jsp')
FROM DUAL) sal from <source_table_name>

What are the differences between oltp and olap?

972

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2066

---

What does “tail –f” command do and what is its use as an Informatica admin.

1107

---

What is informatica powercenter repository?

1202

---

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 pmcmd command?

1121

---

Scheduling properties,whats the default (sequential)

1955

---

Define pmcmd command?

1042

---

How can we store previous session logs?

1081

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1264

---

How you can differentiate between connected lookup and unconnected lookup?

1062

---

Briefly describe lookup transformation?

1046

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4109

---

What are the data movement modes in informatica?

1153

---

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

8119

---