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
Can u generate reports in Informatica?
How to create or import flat file definition in to the warehouse designer?
What is data caches/ index caches?
scenario where i can use only concurrent execution of workflow.
How can you define user defied event?
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?
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?
What is the meaning of decode in informatica?
How do you convert single row from source into three rows into target?
How to do unit testing in informatica?
What are the performance considerations when working with aggregator transformation?
Performance tuning in UNIX for informatica mappings?
Explain what are the different versions of informatica?
How do you set a varible in incremental aggregation
Is there any target staging area in informatica not staging area