Latest Answer: It is not possible ...
I am getting following error when i tried to run Informatica job through a UNIX script.The error is ERROR: Invalid user name or password.WARNING: Lost server connection.The user name and password is correctly
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
Latest Answer: the real meaning of fact is what are all the necessary information for a business.Ex: in a business, customer,item,order,invoices tells information.calculation of amt to be paid by the customer is the main concept of the business.so that type are called as ...
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 ...
Latest Answer: there are 3 scd typesscd type1: Only current detailsscd type2: History + current detailsscd type3: Initial + current detailsIn projects, we mainly use scd type1 ...
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?
Latest Answer: It is also called as fixed dimension.It is a dimension which doesnot effect with respect to time.for example if the name of the city is changed from bombay to mumbai,the name will not change from time to time,once the change is done ,The change is permanent.This ...
if flat files is your source. what are the option in session to take bulk of files from same folder have the same structure of all the files..
Latest Answer: For that you can select source file type as indirect and you have to specify that folder path at source file directory. ...
View page << Previous 13 14 15 16 [17] 18 19 20 21 22 Next >>
Go Top
