In the SEQ generator which property has to be set to
generate seq No. when the input data is more than the max
limit.
Answers were Sorted based on User's Feedback
Define Dynamic push down optmization?
how do u automate Extraction process?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
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)
Do we need an etl tool?
what are the concerns of OLTP and DSS systems?
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
Compare etl & elt?
Identifying the bottlenecks in various components of Informatica and resolving them.
What is full load & incremental or refresh load?
WHY CANT WE SEE THE DATA IN DATASET
Explain the difference between etl tool and olap tools?