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 |
hw cn v elimate dublicate values from lookup without overriding sql?
How will u pas the data with out debugger?
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
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
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is a grid in Informatica?
What is the difference between sequential batch and concurrent batch and which is recommended and why?
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
sorce is a flatfile only 1st and last row should insert to target how will u do?