What is different between the data warehouse and data mart?


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

Post New Answer

More Informatica Interview Questions

What is the Hierarchy of DWH?

1 Answers  


i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,


can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,


we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

3 Answers   Cognizant,


Enlist the various types of transformations.

0 Answers  






What are the mapping parameters and mapping variables?

0 Answers   Informatica,


When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  


i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,


HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,


I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers   HCL,


Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers   Informatica,


What is lookup change?

0 Answers  


Categories