explain the methodology of Data Warehousing?(Polaries)
No Answer is Posted For this Question
Be the First to Post Answer
how to load the data to fact table?
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.
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
Identifying the bottlenecks in various components of Informatica and resolving them.
How many types of transformations supported by sorted input?
what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.
what is the meant by Normalization and de-normalization?
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 is the difference steps for data modeling?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
Explain do we need an etl tool?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?