-
Dimension Table Vs Fact Table
What is the main difference in the logic when you create a mapping for a dimension table with that of a fact table in Informatica.
-
hw to work with pmcmd on windows platform
Joe
- Feb 7th, 2013
ECHO OFF This automates the informatica workflow run using pmcmd ECHO c:informaticaserverinpmcmd startworkflow -u username -p password -s server:host -f Folder -wait MYWORKFLOW
dl_mstr
- Feb 11th, 2008
C:-->Program Files-->Informatica PowerCenter 7.1.3-->Server-->bin-->pmcmd.exe
-
What happens if cache name is not entered in the lookup ?
-
is there any relationship between java & inforematica?
phanimv
- Oct 18th, 2006
Like java, informatica is a plat-form independent, portable and architechtural nutral.
-
In a flat file sql override will work r not? what is the extension of flatfile.
phanimv
- Oct 18th, 2006
Using flat files sql override willnot work. the extension of the flat files are .txt,.doc,.dat and the output or target flatfile extension is .out
Rajesh
- Oct 10th, 2006
In Flat file SQL Override will not work. We have different properties to set for a flat file. If you are talking about the flat file as a source it can be of any extension like .dat,.doc etc. Yes if i...
-
what r the types of target loads
n k rajkumar
- Oct 18th, 2006
There are two types of target load typesthey are1. bulk2. normal
-
How to delete the DSN name or DSN link from the informatica designer.
-
i have a flat file which i am using as my source , i want to match the records in the flat files with that of my oracle table(using cust_id field). I was advised that i should be using a look up transformation and a filter transformation for this. I am not understanding why i should be using the look up transformation. can anyone please helpThanksNayana
anupama2000
- May 26th, 2008
The purpose of using lookup transformation is to check the existing data in target table with the column cust_id after satsifying the condition the rows obtained are used according to your business logic using filter transformation
SRIRAM N
- May 9th, 2007
You should use joiner, then you can use filter if you want, or you can enter the filter condition in joiner as well.
-
what is the difference between ODS and OLTP
dave
- Aug 6th, 2011
ODS is a datastore that contains wide breath of data but not very deep(aggregated not atomic levels), OLTP is used to describe the transaction profile that will access the ODS, small predictable trans...
njvijay
- May 12th, 2008
1. ODS - It is a decision support system which contains snapshot of current data for day to day analysis. This may include little history data also OLTP - It is a trasaction system t...
