Explain the use lookup tables and Aggregate tables?
Two different admin users created for repository are________and_________.
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
explain the methodology of Data Warehousing?(Polaries)
how does the server recongnise the source and target databases.Elaborate on this
what is an ETL or ETT? And what are the different types?
how would u estimate the size of Aggregator transform data and index cache?
How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step
Explain what are the various etl tools in the market?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)