Answer / nsatyabrat7

facts are 3 types.

1. Addictive
2. Semi Addictive
3. Non Addictive

Answer / shital.mylove@gmail.com

4 different types of facts
1.Addictive
2.Semi Addictive
3.Non Addictive
4.Factless Fact Table

Answer / thotli

ADDITIVE example is sales
semi additive example is current balance
non additive example is student attendance

On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 Answers  

---

What is a poling?

2 Answers  

---

When will you use SQL override in a lookup transformation?

1 Answers  

---

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers  

---

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,

---

---

If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  

---

Can you copy the session to a different folder or repository?

1 Answers  

---

Explain the informatica workflow?

0 Answers  

---

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,

---

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,

---

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

3 Answers   Cognizant,

---

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

---