Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11943 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 |
In which scenario did u used Mapping variable?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
Which is the t/r that builts only single cache memory?
What are the tasks that Loadmanger process will do?
What is decode in static cache?
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
What is mapping debugger?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
Whatis the difference between View and Materialized View ?
Teradata 
