Answer Posted / a

select yr,acc, max(decode (mon,'jan',am)) mon1,max(decode
(mon,'feb',am)) mon1,max(decode (mon,'mar',am)) mon1 from
intr
group by yr,acc

Is it possible to define a single node as a Gateway node as well as worker node?

1129

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2351

---

How do you promote a non-reusable transformation to reusable transformation?

1138

---

What are the various types of transformation?

1186

---

Explain the use of aggregator cache file?

1263

---

What is incremental aggregation?

1091

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1182

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1518

---

What do think which one is the better joiner or look up?

1208

---

What is Index Caches size?

1125

---

What are the types of schemas we have in data warehouse and what are the difference between them?

949

---

What are the new features of informatica 9.x at the developer level?

1049

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2239

---

What is a filter transformation?

1050

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2051

---