In a concurrent batch if a session fails, can you start again from that session
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
Explain the aggregator transformation?
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,
What are mapplets? How is it different from a Reusable Transformation?
What are the performance considerations when working with aggregator transformation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How do we implement materialized view?when to use materialized view?
Explain about Informatica server process that how it works relates to mapping variables?
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
How You Pull the records on daily basis into your ETL Server.
What is polling in informatica ?