what is data modeling?
No Answer is Posted For this Question
Be the First to Post Answer
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
what is SMP AND MPP?
what is the difference between date cache and lindex cache?
What is etl process. How many steps etl contains explain with example?
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.
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
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 pmrep command?
What are your responsibilities as an etl tester?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
how do u set the size of block buffer?