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.
No Answer is Posted For this Question
Be the First to Post Answer
what is pmrep command?
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
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.?
Is hadoop a etl tool?
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.
Which transformation we use to convert 'NA' to 'Not Available'
can cubes contain measures ?
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 are Lookup caches options? Including persistent caches.
In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
How etl testing is different from database testing?