When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
976What 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
what is granularity in Data ware House?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
what is the meant by Normalization and de-normalization?
dimension object created in oracle can be imported in designer?how?
Explain do we need an etl tool?
What is a mapping?
Give the benefits of data integration suite?
SCD2 will work on only dimension tables as well as fact Table?
What is data modeling and data mining?
where we cannot use sorter Transformation. if we use then we will not get correct data?
How many steps etl contains explain with example?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
What is a lookup table in etl?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?