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
- 11773 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
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
server hot-ws270 is connect to Repository B. What does it mean?
What are the different types of transformation available in informatica.
Explain the aggregator transformation?
What is joiner change?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Explain the different kinds of facts.
where to store informatica rejected data?
What are the components of workflow manager?
What is union transformation in informatica?
What are the uses of etl tools?
What is an expression transformation in informatica?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is a dimensional model?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
