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.........

What is substr in informatica?

0 Answers  

---

how to load only the first and last record of a flat file into the target?

8 Answers   CTS,

---

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,

---

What is sorter transformation?

0 Answers  

---

version controlling in informatica?

3 Answers  

---

Do joiner transformation use cache? If so describe?

2 Answers   Patni,

---

If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?

5 Answers   TCS,

---

get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers   Infosys,

---

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers   TCS,

---

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 Answers  

---

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,

---

Why filter transformation is an active one?

0 Answers  

---