Answer / krishna

A dimention table which is type of boolean or flag. its not
used in the business analysis

Answer / chandrasekar

A Dimension which not participated in the key performance
indicator.

Eg : phone number, address.

If it is wrong means please mail me chandranmca2007@gmail.com

Answer / chinmay

Junk dimesnion is aimension table consisting attributes
that do no belong to any fact table or any form of existing
dimesnion .
Usually it is used to hold indicator yes/no , true/false.

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,

---

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

---

What are the methods for creating reusable transforamtions?

2 Answers  

---

What is IQD file?

1 Answers  

---

what is threshold error in informatica?

1 Answers   TCS, Wipro,

---

---

Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

3 Answers   Cap Gemini, Puma, Wipro,

---

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  

---

What is difference between maplet and reusable transformation?

2 Answers  

---

How to eliminate duplicates from flat file..what is the procedure

4 Answers  

---

How to eliminate 1st and last rows from the source and load the inbetween rows.

5 Answers   Syntel,

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

0 Answers   HCL,

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,

---