what are challenges that you faced in testing? give solution
to it?
Answer / abhinav prakash
There are multiple challenges while doing testing in Warehousing.
1.Checking if the sequence generator is throwing the correct the value
2.If we are using any FF as a source or target see to it that it has enough read and write permission.
3.Checking step by step if the required business login is implemented correctly(You can use the test load option)
Is This Answer Correct ? | 2 Yes | 1 No |
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
Plz can any one say me how to get the informatica certification materials and dumps
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
What is an Integration service in Informatica?
What are Business Components in Informatica?
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?
What are the different types of olap? Give an example?
what is worklet and what use of worklet and in which situation we can use it?
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 to we create datamart?
i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500