what is granularity,what type of granularity we will take
in fact tables either lowlevel or highlevel,if two tables
having same granularity that is posiable or not


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

How to delete duplicate row using informatica?

0 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,


My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,


What is the method of seperating unique and duplicate records in session level?

2 Answers   Emphasis, JBL, Wipro,


What do think which one is the better joiner or look up?

0 Answers  






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)?

3 Answers   IBM, Patni, TCS,


Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,


where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  


i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,


what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,


Using Expression transformation how to remove duplicate records from a relational source?

4 Answers  


what is datamart

4 Answers   IBM, Informatica,


Categories