Please let me know how we can implement the below scenario.
In a single mapping,more than 500 sources
(legacy,VSAM,relational) will be loading into only one
target. Whenever I retreive the data(any record) from
target, i need to find the details that the record belongs
to which source.
Thanks in advance..
Answers were Sorted based on User's Feedback
Answer / bidhar
Here i am assuming that your single warehouse table has
data from more than one source,and you need to distinguish
the data among the sources.
For this to accomplish you can have table which can have 2
columns Datasourcename and ID.This table will have all the
source list and ID column will be the surrogate key.
Now you need to alter your warehouse table by adding a new
column called Source Identifier.
Now you have the architecture ready.
When loading your warehouse table just look up the first
table for the source name and pickup the corresponding
surrogate key and populate into the Source identifier
column in the warehouse table.Use this Column(Source
Identifier)to identify the sources.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / amarnath
if u r using informatica 8.0 n above u have a option to
load the name of the file. this is in the sq itself just
check the currently processed file name box. remember this
will give u the complete path of the file, hence u need to
substring it before loading it to tgt
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / arnab
create a system where you can identify a source with an
ID.you may call it as datasource_num_id , build a cross
reference table to store all tis information , in the map
you can use this cross reference table to get the ID and
populate this id in ur target table
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vdiwade
Yes its possible through above logic…In addition to Srinu
idea....you can understand very easy way. Suppose creare one
(specific src) insert script.. means for 500 sources,500
insert script,which loads data into one src/tgt…we can add
one more column source_name tht will be always coming
source_name..so at the time of retrieving we can easily
understand this records belongs which source/tgt tbl.
Is This Answer Correct ? | 0 Yes | 1 No |
To achieve the session partition what r the necessary tasks u have to do?
What is the difference between informatica 8.x and 9.x
what is a transforamation?
What are data-driven sessions?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
When do you use mapping parameters? (In which transformations)
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How can you complete unrcoverable sessions?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
how will you remove the duplicate records from flat file without using sorter?
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
What is informatica? Why do we need it?