without matching columns in two tables. how can you join

Answer Posted / manjunath

Case 1 : If we want to join two tables we need matching column based on condition.
Case 2 : If we join two tables without column then go for union T/R

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention few advantages of router transformation over filter transformation.

868


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1825


Different circumstance which drives informatica server to expel records?

768


Can we get 1st record through Informatica(without sequence number).

1247


What is the difference between STOP and ABORT options in Workflow Monitor?

981


Explain the different kinds of facts.

770


Why update strategy and union transformations are active?

839


How identifying bottlenecks in various components of informatica and resolving them?

890


Enterprise data warehouse your projects phase by phase explain?

1700


What are the features of complex mapping?

914


can we override a native sql query within informatica? How do we do it?

894


Slowly changing dimensions, types and where will you use them

1505


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1886


What is fact table? Explain the different kinds of facts.

831


Explain the pipeline partition with real time example?

918