Compare ETL & Manual development?
No Answer is Posted For this Question
Be the First to Post Answer
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?
when should one create lookup transformation ?
What are the names of the layers in etl?
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 difference between cardinality and Nullability?
how do u implement unconn.stored proc. in a mapping?
how would u estimate the size of Lookup transform data and index cache?
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)
what are the different forms of normalization?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?