tell me some dimension tables names in banking domain informatica project(dont

tell me some dimension tables names in banking domain
informatica project(dont tell like depends on project, tell
me names of dimension and fact table names in your project)?

Question Posted / naresh kumar

3 Answers
25335 Views
IBM, Patni, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

tell me some dimension tables names in banking domain informatica project(dont tell like depends on..

Answer / im

Fact Tables:

1)Bank
2) Advanced

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

Is This Answer Correct ?

15 Yes

1 No

tell me some dimension tables names in banking domain informatica project(dont tell like depends on..

Answer / madhu

d_acctbal
d_party
d_account
d_adress
d_contact

Is This Answer Correct ?

3 Yes

0 No

tell me some dimension tables names in banking domain informatica project(dont tell like depends on..

Answer / lokesh

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

Is This Answer Correct ?

9 Yes

12 No

Post New Answer

More Informatica Interview Questions

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 Answers

What is a code page?

0 Answers

performance wise which one is better in joiner and lookup transformation

2 Answers

write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers Tech Mahindra,

major difference between normal loading and bulk loading?

6 Answers

Whats the difference between $, $$, $$$

9 Answers

Explain the aggregator transformation?

0 Answers

When will you use SQL override in a lookup transformation?

1 Answers

without dynamic lookup how to insert new rows and update existing rows?

1 Answers HP,

what is update strategy transformation ?