-
What is meant by source is changing incrementally?
What is meant by source is changing incrementally?Explain with an example?
-
UNIX commands in informatica
What is the purpose of using UNIX commands in informatica?Which UNIX commands are generally used with informatica?
-
Sorter in Active Transformation
Why is sorter an active transformation? What happens when you uncheck the DISTINCT option in sorter?
-
Load the remaining rows
Suppose there are 100,000 rows in the source and 20,000 rows are loaded to target. Now in between if the session stops after loading 20,000 rows how will you load the remaining rows?
-
Loading data from Datamarts
Which approach is better and why?Loading data from datamarts to datawarehouse or vice versa?
-
What is the need for an ODS(operational data store)
What is the need for an ODS(operational data store) in data warehousing?What are the advantages of using an ODS?