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 |
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
What is different between informatica version 8 and 9 version
What is the term PIPELINE in informatica ?
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
in which situations do u go for snowflake schema ?
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
What is the difference between a connected look up and unconnected lookup?
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
What is mapplet in informatica?