What r the defferent types of dimension tables?how can we join the table if they have no matching point and related keys?
Where exactly dimension and fact tables are useful? Is it source or target?We are importing source directly from database and transforming and loading the data to target.Can anybody please send where they exactly it is useful?
Hi, I have a COBOL file and contains 500 records of sample data.It contains 200 columns.How can I split that file in Informatica?Like 1st file 1-80 columns and 2nd file 81-200 columns.Then I want load that data using Informatica.The Target are Oracle tables.1-80 columns: 1st target81-200 columns:2nd targetHow can I split that single COBOL file data into two data files and How can I load that data using Informatica.Thanks in Advance
Hi,
I have a COBOL file and contains 500 records of sample data.It contains 200 columns.How can I split that file in Informatica?Like 1st file 1-80 columns and 2nd file 81-200 columns.Then I want load that data using Informatica.
The Target are Oracle tables.
1-80 columns: 1st target
81-200 columns:2nd target
How can I split that single COBOL file data into two data files and How can I load that data using Informatica.
Thanks in Advance
What is the difference between using Joiner and Using Lookup to join to tables. Which is good to use.
2 tables are present on 2 oracle databases, How to join those 2 tables? Which transformtion should be used?
1.How do you store Historical data in a DWH?2.What is the primary purpose of using surrogate key? Will those be used in fact tables?If not then what is the purpose in using it?3. How do you update Information in Update strategy Transformation?4. How do you validate data after you have transfered it into target table from flat files?
how to join the data of two tables which do not have common columni mean how to perform non equi join in informaticaEg:just like getting data from emp and salgrade table of oracle where sal is between
Latest Answer : The relationship between the EMP table and the SALGRADE table is a
non-equijoin, meaning that no column in the EMP table corresponds directly to a
column in the SALGRADE table. The relationship between the two tables is that
the SAL column in the ...
My Business case is to develop a informatica mapping for a Stored Procedurei have a cursor in a SP which has 5 tables in 'from' .. with some where conditions. how to develop mapping and fetch all the values
I have to load data from DB2 flat file to MS SQL Server target tables.
Latest Answer : In the session Mapping properties select the source file and specify the path where it is residing.RegardsMamatha ...
