what is the size of your data warehousing?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.1 2726
What is the need of building a data warehouse?2 3019
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
I need an oracle query for convert Char to Integer?. Can any one help me how to do this?3 4244
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...1 2563
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....1 2142
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain how many types of dimensions are available in informatica?
Differentiate between router and filter transformation?
What are Dimensional table?
What are different types of transformations available in informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How to extract sap data using informatica?
What is the way to execute pl/sql script using informatica mapping?
Differentiate between reusable transformation and mapplet.
Explain sql transformation in script mode examples in informatica
Whats the difference between informatica powercenter server, repositoryserver and repository?
Please let me know how to make encryption and decryption with example?
Explain about Informatica server process that how it works relates to mapping variables?
What is meant by incremental aggregation?