What are the types of schemas we have in data warehouse and what are the difference between them?
No Answer is Posted For this Question
Be the First to Post Answer
What is different between informatica version 8 and 9 version
What is the procedure for creating independent data marts from informatica 7.1?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
What is the difference between informatica 8.x and 9.x
How can we improve session performance in aggregator transformation?
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
What are the different lookup cache(s)?
Performance wise which is better joiner or look up ? Give me with example?
expain about the tune parameters?
What is log file,and where is it located,why u r using the log file
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?