What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
No Answer is Posted For this Question
Be the First to Post Answer
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
How will you combine 3 different sources with a single source?
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
what is the flow?
What is the function of look up transformation?
How Union Transformation is an Active Trans?
what are the types of Data warehousing ?
Without using any transformations how u can load the data into target?
Why do we need informatica?
I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
What is limitations of truncate and load option