What are the challenges you have faced in your Project (DWH-
ETL)? Explain with example?
No Answer is Posted For this Question
Be the First to Post Answer
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
What is InformaticaPowerCenter?
Router T/R is active but some people are saying it is also passive which is exactly right?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
Why we use ENABLE HIGH PRECISION in session properties?
What are the types of lookup?
what is degenerated dimension table with scenario
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How to elaborate powercenter integration service?
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?