how to join the 2 different table with different columns in
informatica?
Answer Posted / krishna
By Handling on this we go for joiner tr make sure that there
is a common coloumn b/w the two tables.other wise not possible.
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How are the sources and targets definitions imported in informatica designer?
What are active and passive transformations?
How many input parameters can exist in an unconnected lookup?
What are the components of the workflow manager?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is data movement mode in Informatica and difference between them?
Where can we find the throughput option in informatica?
What are roles and groups and benefits of using them?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
where to store informatica rejected data? How to extract the informatica rejected data?
what is the hint? how to use it to reduce the query processing in program?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
where to store informatica rejected data?
What are mapplets? How is it different from a Reusable Transformation?
Describe the impact of several join conditions and join order in a joiner transformation?