without matching columns in two tables. how can you join

Answer Posted / sarthak

U can't join two tables (without matching columns) through
UNION T/f.It requires matching columns for UNION.

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can u generate reports in Informatica?

663


How to create or import flat file definition in to the warehouse designer?

624


What is data caches/ index caches?

623


scenario where i can use only concurrent execution of workflow.

2562


How can you define user defied event?

635






My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5589


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

800


What is the meaning of decode in informatica?

658


How do you convert single row from source into three rows into target?

616


How to do unit testing in informatica?

735


What are the performance considerations when working with aggregator transformation?

684


Performance tuning in UNIX for informatica mappings?

2158


Explain what are the different versions of informatica?

667


How do you set a varible in incremental aggregation

1457


Is there any target staging area in informatica not staging area

2138