without matching columns in two tables. how can you join

Answer Posted / sbvp

by using union t/r
other wise create one dummy column in two tables
than join the two table with jioner t/r
ok

Is This Answer Correct ?    13 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

waht type of interface is used for testing the data in informatica

1828


Which version configuration tool used in ur project?

2762


How to use procedural logic inside infromatica?

630


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1638


What is the status code in stored procedure transformation?

683






What is sorter transformation?

576


What is incremental aggregation?

570


What is repository manager?

533


What are the issues you have faced in your project? How did you overcome those issues?

1908


What is deployment group?

680


What are the advantages of informatica?

568


How to create the source and target database connections in server manager?

621


How to generate sequence numbers without using the sequence generator transformation?

638


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1780


Have you worked with/created Parameter file

1224