Interested to Buy Any Domain ? << Click Here >> for more details...
Hi I have two sources like A, B. My source A contain 10000
million records from that i need 20 attributes. My source B
has also same 10000 million records from that i need only 1
attribute. By using Joiner i have to load into target? Is
there any issue regarding this? if issue is there how to
tune this mapping in best way?
- 2 Answers
- 6778 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / anu
IF 2 SOURCES ARE RELATIONAL USE SQ T/R
WRITE MANUVAL QUERY
first connect requrired 16+1 attributes to furter t/r or target
select required columns and in where condition write matched condition
if there is no common column go to joiner create sequence in both sources then compare sequence in join vondition
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the new features of informatica 9.x at the developer level?
Design a mapping to load a target table with the following values from the above source?
How to use pmcmd utility command?
lookup transformation with screenshots
What is a joiner transformation?
How can we update a record in the target table without using update strategy?
What is a pre-defined event and user-defined event?
What is the need of an ETL tool?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How do you promote a non-reusable transformation to reusable transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain informatica architecture - version 8 / 9
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is sorter transformation?
