-
Separating Single Field to Values
I have a table having column col1, col2. If for a col1 there is some data in col2. EX: Col1=0012 and Col2 = 12,13,14 then i need these three values 12, 13,14 separately not as a single string as it is in table. Or you can say in need to separate these three values after it is returned by query.There may be only one value or more than 3 as well. EX: 12,13,14,15.........
-
-
Kill workflows
how to kill 10 workflows at a a time ?
-
-
-
-
-
-
how to join the data of two tables which does not have common columns
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 losal and hisalthanksvenu
-
-
-
-
-
How do you store Historical data in a DWH ?
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 transferred it into target table from flat files?
-
-
How do you handle two sessions in Informatica
can any one tell me the option between the two session . if previous session execute successfully than run the next session...
-
-
-
-
-
-
-
Unable to start my Informatica Repository Service Windows XP and Oracle 10g
I am unable to start my Informatica Repository Service, Even if I start the service, it stops immediately.Please, any one have a solution to this problem(I installed Informatica 7.1 on WINDOWS XP Home Edition, Oracle 10g)Thanks a lot.nagesh
-
Online Analytical Processing?
Online Analytical Processing A tool to evaluate and analyze the data in the data warehouse using analytical queries. A tool which helps organize data in the data warehouse using multidimensional models of data aggregation and summarization. Supports the data analyst in real time and enables online analysis of data with speed and flexibility.
-
-
-
What are Dimensions and various types of Dimensions?
set of level properties that describe a specific aspect of a business, used for analyzing the factual measures of one or more cubes, which use that dimension. Egs. Geography, time, customer and product.