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
How do you convert single row from source into three rows into target?
what is SDLC way of code development?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Explain what are the different versions of informatica?
Explain the code page compatibility?
COM components can be used in Informatica
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is the cumulative sum and moving sum?
What are the new features of informatica 9.x in developer level?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What does role playing dimension mean?
How can we handle two sessions in informatica?
What are the advantages of using informatica as an etl tool over teradata?