why we use datawarehouse
No Answer is Posted For this Question
Be the First to Post Answer
What are Rapid changing dimensions?
one source to target loading insert new rows and update existing rows?
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
how to obtain performance data for individual transformations.
What is data merging,data cleansing,sampling?
1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override
What is meant by incremental aggregation?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
Name 4 output files that informatica server creates during session running?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
What are the different clients of powercenter?