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 |
Difference between Target-based loading and constraint-based loading?
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
Can we call a stored procedure from a unix script which is run using command task
Partition, what happens if the specified key range is shorter and longer
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
Enlist the advantages of informatica.
What is mapping debugger?
In informatica workflow manager, how many repositories can be created?
what are the difference between Informatica 7.1 and 8.1?
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
Under what condition selecting sorted input in aggregator may fail the session?