When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
972What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
1074In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
933
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
What are the etl testing operations includes?
what are the concerns of OLTP and DSS systems?
What is data cleaning?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
how do use session mapping parameters ?(in which transformation)
what is the difference between cardinality and Nullability?
what are the reporting tools and difference between them?
Explain me ETL project architecture in Detail?
what do u do when DB time takes more?in sap bi
what is the use of server manager?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
Compare ETL & Manual development?
What are the steps involved in etl process?
what is the main role of FI on business