Type Source TABLE
TABLE NAME LOCATIONS
23
YES?
source table
LOCATIONS
|
~
HETEROGENEOUS TARGET
HOMOGENEOUSsources
HETEROGENEOUS sources
MAPPING
TARGETS
HOMOGENOEUS
TABLE1 IN ORACLE DB IN OT_TGT
TABLE2 IN ORACLE DB IN OT_TGT
FILE1 IN c:\
FILE2 IN D:\
Targets
SCHEMA CONDITION
LOC_US_TGT OT_TGT_DEV13 COUNTRY_ID='US'
LOC_UK_TGT OT_TGT_DEV13 COUNTRY_ID='UK'
LOC_JP_TGT_FF.dat FILE COUNTRY_ID='JP'
LOC_OTHERS_FF.out FILE others
E:\Informatica\10.2.0\server\infa_shared\TgtFiles
$PMTargetFileDir
1
targets 4
LOC_US_TGT COUNTRY_ID='US'
LOC_UK_TGT COUNTRY_ID='UK'
LOC_JP_TGT_FF.dat COUNTRY_ID='JP'
LOC_OTHERS_FF.out others
TABLE1 ot_src_Dev oracle
TABLE2 ot_src_Dev oracle
TABLE ot_src_Dev oracle
File1 E:\Informatica\10.2.0\server\infa_shared\SRCFiles
file2 E:\Informatica\10.2.0\server\infa_shared\SRCFiles
file3 E:\Informatica\10.2.0\server\infa_shared\SRCFiles
targets
TABLE1 ot_tgt_dev1
TABLE2 ot_stg_Dev1
table1 oracle ot_tgt
table2 sqlserver
table3 oracle ot_Stg
table1
file
TARGETS
HETEROGENEOUS
TABLE1 IN ORACLE DB IN OT_TGT
TABLE2 IN ORACLE DB IN OT_TGT
TABLE3 IN ORACLE DB IN OT_STG
FILE1
TABLE5 IN SQL SERVER DB
4 TARGET TABLES
|
~
r\infa_shared\SRCFiles
r\infa_shared\SRCFiles
r\infa_shared\SRCFiles
Type Source TABLE
TABLE NAME EMPLOYEES
107
HETEROGENEOUS TARGET
HOMOGENEOUSsources
HETEROGENEOUS sources
MAPPING
TARGETS
HOMOGENOEUS
TABLE1 IN ORACLE DB IN OT_TGT
TABLE2 IN ORACLE DB IN OT_TGT
FILE1 IN c:\
FILE2 IN D:\
Targets
SCHEMA
EMP_TGT_ACC OT_TGT_DEV13
EMP_TGT_PRO OT_TGT_DEV13
EMP_TGT_PC.out FILE
EMP_TGT_SM.dat FILE
EMP_TGT_SC.csv FILE
EMP_TGT_OT OT_TGT_DEV13
TABLE1 ot_src_Dev
TABLE2 ot_src_Dev
TABLE ot_src_Dev
File1 E:\Informatica\10.2.0\server\infa_shared\SRCFiles
file2 E:\Informatica\10.2.0\server\infa_shared\SRCFiles
file3 E:\Informatica\10.2.0\server\infa_shared\SRCFiles
targets
TABLE1 ot_tgt_dev1
TABLE2 ot_stg_Dev1
table1 oracle
table2 sqlserver
table3 oracle
table1
file
TARGETS
HETEROGENEOUS
TABLE1 IN ORACLE DB IN OT_TGT
TABLE2 IN ORACLE DB IN OT_TGT
TABLE3 IN ORACLE DB IN OT_STG
FILE1
TABLE5 IN SQL SERVER DB
CONDITION
JOB_TITLE='Accountant' 4 TARGET TABLES
JOB_TITLE='Programmer'
JOB_TITLE='Purchasing Clerk' ~
JOB_TITLE='Sales Manager' |
JOB_TITLE='Stock Clerk' ,
other than the above job tiles
oracle
oracle
oracle
matica\10.2.0\server\infa_shared\SRCFiles
matica\10.2.0\server\infa_shared\SRCFiles
matica\10.2.0\server\infa_shared\SRCFiles
ot_tgt
ot_Stg
filter
1 Single input , single ouput
2 can work only one filter conditon
3 filter Tr will read the record every time for evey filter tr
4 if the condition is not satisfiled , filter wil drop the record
HOMOGENEOUS TARGETS
all TARGET tables from same schema and same db
OR
all TARGET files from same location
router
single input group , multple output groups , one default group
will work multiple filter conditions
Router will read the recod only time for all the incoming records
but we have an to capture the not satisfiled records by using default
HETEROGENEOUS TARGETS
table1 from oralce db
table2 from sql server db
table3 from oracle db but from ot_stg schema
table 4 from oracle db but from dt_tgt schema
2 tables from oracle from same schema and 2 files
ACCENTURE
ICICI BANK
ICICI CLIENT CUSTOMERS
USER SOURCE TARGET EMPLOYEES
BUSSINESS CREDIT CARD
STAKE HOLDER OLTP OLAP LOANS
DATABASE DATAWAREHOUSE
ICICI BANK SOURCE CONNECTION DETAILS MAPPING DOUCMENTS
USERNAME /SCHEMA NAME
PASSWORD BA
HOSTNAME DA
PORT NUMBER DBA
SID TEAM LEAD
A DEVELOPER WILL NEVER CREATE SOURCE SCHEMA , SOURCE TABLE ,SOURCE DATA.
DAILY
WEEKLY
MONTHKY
QUALR
TRANSFORM
SOURCE TARGET
OLTP OLAP
TRANSACTIONS
RAW DATA ANALYSED DATA
TARGET SHCEMA
TARGET TABLE WILL CREATED BY DBA
MAPPING DOUCMENTS
SOURCE INFORMATION
BUSINESS LOGIC
TARGET INFORMTION
DOUCMENTS
MONTHKY
COUTRY US TGT_us
UK TGT_UK
INDIA TGT_INDIA
JAPAN TGT_JAPAN
COUNTRY_src COUNTRY='UK' TGT_UK
COUNTRY='us' TGT_us
COUNTRY='INDIA' TGT_INDIA
COUNTRY='JAPAN' TGT_JAPAN
