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.
- 0 Answers
- 1953 Views
- I also Faced
- E-Mail Answers
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
Which type or t/s is used to convert rows into column & column into rows
how do u handle performance issues in Informatica . where can u monitor the performance ?
what is HISTOGRAM? how to generate statistics?
Explain etl mapping sheets?
Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?
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 are your responsibilities as an etl tester?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
how do u really know that paging to disk is happening while u are using a lookup transform?
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?
flat filevalidation in informatica
Teradata 
