Answer / im

Fact Tables:

1)Bank
2) Advanced

Dimension Tables:
1)Customer
2)Account
3)Transation Dirty Dimension
4)Time

Answer / madhu

d_acctbal
d_party
d_account
d_adress
d_contact

Answer / lokesh

Table which contains account number,customer numbers.........

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,

---

what is row level and column level indicator?

1 Answers   TCS,

---

What is meant by LDAP users?

0 Answers  

---

I have 1200 records how can u send it in aggregator with good performance issues?

3 Answers  

---

Whatis the difference between View and Materialized View ?

11 Answers   Satyam, Syntel,

---

what is dimension table?

17 Answers  

---

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

4 Answers   Magna Infotech,

---

How we can use union transformation?

0 Answers  

---

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  

---

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,

---

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,

---

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  

---