What the difference is between a database, a data warehouse and a data mart?


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

Post New Answer

More Informatica Interview Questions

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

0 Answers   Amazon,


Explain the different lookup methods used in informatica?

0 Answers  


What is the commit type if you have a transaction control transformation in the mapping?

0 Answers   Informatica,


Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,


What is limitations of truncate and load option

1 Answers   Cap Gemini,






What is rank transformation?

0 Answers  


What are Rapid changing dimensions?

1 Answers  


Difference between Data and Index Caches?

0 Answers   Informatica,


 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,


How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  


what is size of u r database?

0 Answers  


how to get the only updated records in the target

2 Answers  


Categories