can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine.
we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??
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'
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you
when will use SQL override in a lookup transformation?
what are Lookup caches options? Including persistent caches.
What are the etl testing operations includes?
What are the steps involved in etl process?
how to connect to a flatfile through ftp in informatica
how would u estimate the size of Aggregator transform data and index cache?
how many steps are there in etl process?
How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step