What is different between the data warehouse and data mart?
No Answer is Posted For this Question
Be the First to Post Answer
What is the Hierarchy of DWH?
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
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?
Enlist the various types of transformations.
What are the mapping parameters and mapping variables?
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
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?
HOW DO YOU PARFORM INCREMENTAL LAOD ?
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
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is lookup change?