How can we join the tables if they don't have primary and
foreign key relationship and no matching port?
Answer Posted / lokesh
Manually add dummy cols to both table with same data type and join dem with joiner transformation
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Write the unconnected lookup syntax?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What are the advantages of informatica?
What is depict expression change?
Partition, what happens if the specified key range is shorter and longer
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are the components of workflow manager?
How are indexes created after completing the load process?
What are the advantages of using informatica as an etl tool over teradata?
What is data caches/ index caches?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
what is the hint? how to use it to reduce the query processing in program?
Can anyone tell me the new features in Informatica 9 Version?