What are the types of schemas we have in data warehouse.


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

Post New Answer

More Informatica Interview Questions

What are the types of lookup?

3 Answers   Wipro,


What is the benefit of partitioning a session?

0 Answers  


What are multi-group transformations?

0 Answers   Informatica,


whats the option in informatica 7 version is outdated in informatica 8 version onwards.

1 Answers   iGate,


source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,






ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

3 Answers   HP,


Why do you use Mapping Parameter and mapping variable?

0 Answers  


Which files are created during the session rums by informatics server?

0 Answers  


can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  


Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  


How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

2 Answers   IBM,


What is the difference between view and materialised view?

6 Answers  


Categories