What are the types of schemas we have in data warehouse and what are the difference between them?


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

Post New Answer

More Informatica Interview Questions

What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,


What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  


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,


While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  


What is the difference between informatica 8.x and 9.x

1 Answers   Wipro,






How can we improve session performance in aggregator transformation?

0 Answers   Informatica,


My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...

2 Answers   Accenture,


What are the different lookup cache(s)?

0 Answers  


Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,


expain about the tune parameters?

0 Answers   TCS,


What is log file,and where is it located,why u r using the log file

1 Answers   TCS,


My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

2 Answers   Span Systems,


Categories