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
Mention few advantages of router transformation over filter transformation.
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.
Different circumstance which drives informatica server to expel records?
Can we get 1st record through Informatica(without sequence number).
What is the difference between STOP and ABORT options in Workflow Monitor?
Explain the different kinds of facts.
Why update strategy and union transformations are active?
How identifying bottlenecks in various components of informatica and resolving them?
Enterprise data warehouse your projects phase by phase explain?
What are the features of complex mapping?
can we override a native sql query within informatica? How do we do it?
Slowly changing dimensions, types and where will you use them
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is fact table? Explain the different kinds of facts.
Explain the pipeline partition with real time example?