Do we need an etl tool?
No Answer is Posted For this Question
Be the First to Post Answer
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
What is a mapping?
What are the different etl testing categories as per their function?
What is grain of fact?
how many steps are there in etl process?
How to fine tune mappings?
what are Lookup caches options? Including persistent caches.
Difference between flat files and relational sources?
IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.
What is etl process? How many steps etl contains?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What is staging area referring to?