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

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

---

What are the different lookup cache(s)?

0 Answers  

---

In which circumstances that informatica server creates Reject files?

2 Answers  

---

Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 Answers  

---

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,

---

difference between informatica 8.6 and 9

3 Answers   Atos Origin, BA Continnum Solutions, Core Logic,

---

Which is the t/r that builts only single cache memory?

0 Answers  

---

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,

---

Explain incremental aggregation in informatica

0 Answers   Informatica,

---

how to use incremental load?

2 Answers   TCS,

---

What is checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,

---

Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 Answers  

---