Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Triggers in Informatica 1

Status
Not open for further replies.
obieedev

obieedev

Technical User
Feb 16, 2011
2
0
0
US
Hi,

I have a requirement where the report has to capture whenever a Customer change his/her address. I want to apply triggers and staging tables in informatica. Can someone please help me out how to approach this Issue

Thank You
 
Sort by date Sort by votes
Triggers are defined in the database. When you define a 'for update' trigger on a database column, then you can define an action , like writing an entry to a logging table The logging table can then be sourced in the ETL process..

Ties Blom

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Ulianna
  • Locked
  • Question
Loading files from different sources into one database table
Replies
1
Views
64
johnherman
johnherman
hmohsen
  • Locked
  • Question
Aggregating Random Forests in PMML
Replies
0
Views
74
hmohsen
hmohsen
Edward1984
  • Locked
  • Question
Data mining in text logs: associating sentences with each other
Replies
2
Views
90
Edward1984
Edward1984
dmishra
  • Locked
  • Question
Implement OLAP Lead Function in Informatica
Replies
1
Views
26
blom0344
blom0344
Vivarto
  • Locked
  • Question
Attributes of two dims in an N dim fact table
Replies
3
Views
98
blom0344
blom0344

Part and Inventory Search

Sponsor

Back
Top