What are the different types of schemas?

Answers were Sorted based on User's Feedback



What are the different types of schemas?..

Answer / priya

star scema an snowflake schema

Is This Answer Correct ?    5 Yes 25 No

Post New Answer

More Informatica Interview Questions

What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,


Enlist the various types of transformations.

0 Answers  


What are the basic needs to join two sources in a source qualifier?

3 Answers  


The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,


what is diff b/t sorter t/r and agg have the option sorter property...

0 Answers  






Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,


how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.

5 Answers   Keane India Ltd,


What do you understand by SOA of Informatica?

0 Answers  


scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  


Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

2 Answers   CTS,


i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

8 Answers   iNautix,


error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers  


Categories