Explain what is etl process? How many steps etl contains explain with example?
No Answer is Posted For this Question
Be the First to Post Answer
Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks
What is factless fact schema?
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).
Explain do we need an etl tool? When do we go for the tools in the market?
what is the meant by Normalization and de-normalization?
what is the difference between cardinality and Nullability?
what are Lookup caches options? Including persistent caches.
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?
Explain etl?
what are the production issues in datastage?
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)
can be used COM component in Informatica ?