i have two source data there is no pk,fk how to join the
two sources
Answer Posted / chandranmca2007
We can create a a dummy columns for both tables using that
dummy column we can join the both tables. If the both
tables have same column means we can using that join the
both tables.
If I wrong please send the answer to my mail id
chandranmca2007@gmail.com
| Is This Answer Correct ? | 21 Yes | 6 No |
Post New Answer View All Answers
What is sorter transformation?
What are different types of transformations available in informatica?
Clarify the aggregator change?
permutations of mapplet
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 a shortcut and copy in Informatica and how two are different with each other?
Explain the use of aggregator cache file?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What will be the approach?
Enlist the various types of transformations.
Which transformation is needed while using the Cobol sources as source definitions?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is meant by a domain?
write a query to retrieve the latest records from the table sorted by version(scd)
What is workflow manager?