How can we join the tables if they don't have primary and foreign key relationship and no matching port?
7 15882After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
2 7266Post New Informatica Questions
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What will be the approach?
What are the data movement modes in informatica?
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.
How can you generate reports in informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is the need for an etl tool?
What are active and passive transformations?
What is rank transformation?
How to update source definition?
What are the types of caches in lookup? Explain them.
which one is better performance wise joiner or look up
How many ways a relational source definition can be updated and what are they?
What is data transformation manager process?