Data Warehousing Community Forum
February 08, 2012, 10:34:12 pm
Home
Help
Search
Login
Register
Data Warehousing Community Forum
>
ETL Tools
>
Informatica
>
Child Record Deletion
Pages: [
1
]
Go Down
« previous
next »
Print
Author
Topic: Child Record Deletion (Read 1141 times)
Arvind
DW Apprentice
Reputation: +10/-0
Offline
Posts: 78
Child Record Deletion
«
on:
January 21, 2009, 01:55:10 pm »
Friends -
If I
delete
a record from the Master table, then the same record should be deleted from the dependent tables (say - Child tables), for this kind of scenario, which transformation can be used?
Thanks in Adv...
Logged
regards,
Arvind
Sipra
Founder
Reputation: +59/-0
Offline
Posts: 323
Am the King...
Re: Child Record Deletion
«
Reply #1 on:
February 02, 2009, 10:51:12 am »
@Arvind -
There's
No
such a
(Single)
built in Transformation for this scenario.
So you need to do it other way (A mapping which makes this scenario).
Logged
Sipra
Founder
www.dwforum.net
Pages: [
1
]
Go Up
Print
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General Category
-----------------------------
=> Introductions
=> Anouncements & News
=> Suggestions
=> General Discussion
=> Job Opportunities
-----------------------------
Data Warehousing
-----------------------------
=> Data Warehousing Concepts
=> Data Modeling
-----------------------------
Databases
-----------------------------
=> Oracle
===> PL/SQL
=> Microsoft SQL Server
=> IBM DB2
=> Teradata
-----------------------------
ETL Tools
-----------------------------
=> Informatica
===> Installation & Configuration
=> Data Stage
=> Ab Initio
=> Oracle Warehouse Builder
=> DTS/SSIS
-----------------------------
Reporting Tools
-----------------------------
=> Business Objects
=> Cognos
=> Crystal Reports
=> Hyperion
=> Brio
=> Microstrategy
-----------------------------
Operating Systems
-----------------------------
=> UNIX / Linux
===> Unix Shell Scripting
=> Windows
-----------------------------
Other Technologies & Tools
-----------------------------
=> JAVA