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..
- 5 Answers
- 10191 Views
- iGate, I also Faced
- E-Mail Answers
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 |
What are the types of groups in Router transformation?
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
What are the prerequisite tasks to achieve the session partition?
What is the difference between informatics 7x and 8x and what is latest version?
What is the status code in stored procedure transformation?
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
What are the types of lookup?
what is lookup ?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How can i set break points in debugging mode ? can explain steps please?
How can you generate reports in informatica?
why normalizer transformation can not used in mapplet? plzzzz answer
Teradata 
