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
- 11908 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the components of Informatica? And what is the purpose of each?
Can we create a Integration service without a Repository service and vice versa?
Differentiate between reusable transformation and mapplet.
How to convert multiple rows to single row (multiple columns) in informatica
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Is there any way to read the ms excel datas directly into informatica?
How to implement security measures using repository manager?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How can repository reports be accessed without sql or other transformations?
How to configure mapping in informatica?
What is the format of informatica objects in a repository?
write a query to retrieve the latest records from the table sorted by version(scd)
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is workflow? What are the components of workflow manager?
