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
- 12069 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / srinu
Hi ,
After every Source qualifier transformation just keep an
Expression with flag.
Dont go Single Source qualifier trans.
Keep 1 source qualifier trans for one table.
Any corrections let me know ,,,,
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Enlist few areas or real-time situations where informatica is required.
What all are steps in up gradation of Informatica server?
What are batches?
Can anyone tell me the new features in Informatica 9 Version?
Explain scd type 3 through mapping.
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.
What are the features of complex mapping?
Explain constraint based loading in informatica
How can we delete duplicate rows from flat files?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is target load order?
How to generate sequence numbers using expression transformation?
How can we use mapping variables in informatica?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
what is the size of your data warehousing?
