how many steps are there in etl process?
No Answer is Posted For this Question
Be the First to Post Answer
Hi, Lookup() is what kind of join ?
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
2 Answers Accenture, Saama Tech, TCS,
how do u decide whether u need to do aggregations at database level or at Informatica level?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you
if u can't find what you are looking for in lookup table, how do you handle?
Difference between flat files and relational sources?
what are Lookup caches options? Including persistent caches.
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
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?
what is the main role of FI on business
What is etl process. How many steps etl contains explain with example?