How can we join the tables if they don't have primary and
foreign key relationship and no matching port?
Answer Posted / developer
use a union transformation if there are no matching ports.
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Briefly describe lookup transformation?
Define Pmrep command?
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
What if the source is a flat-file?
In informatics server which files are created during the session rums?
Describe expression transformation?
What is the difference between informatics 7x and 8x and what is latest version?
What is the meaning of up gradation of repository?
What do mean by local and global repository?
What is incremental aggregation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is a passive transformation?
what is degenerated dimension?
What is expression transformation?