What is a filter transformation and why it is an active one?
No Answer is Posted For this Question
Be the First to Post Answer
What is a grid in Informatica?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
Where is the cache stored in informatica?
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
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
Briefly explain the aggregator transformation?
what is fact table?
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?