Answer / siddu

IQD:-- Impromptu Query definition file (Report)
Using Catalog(in Impromptu Administration) create a report,
save that report in IQD format,that one you can use as a
source(Meta Data source) in Cognos PowerPlay Transformer

What is the use of incremental aggregation?

2 Answers  

---

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,

---

If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   TCS,

---

What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,

---

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

---

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  

---

Define Pmrep command?

0 Answers  

---

Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,

---

How can you validate all mappings in the repository simultaneously?

0 Answers  

---

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

---

What are the new features of informatica 7.1?

2 Answers  

---

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

---