list and discuss two approaches for updation of target table
in Informatica and how they are different.
No Answer is Posted For this Question
Be the First to Post Answer
what is meant by drill through?(Mascot)
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record
what is the difference between OLTP database and data warehousing database?
how to load the data to fact table?
Mention few test cases and explain them?
Explain about the data integration suite features?
What is ROWID explain ?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
how do u extract data from different data sources explain with an example?