Interested to Buy Any Domain ? << Click Here >> for more details...
without matching columns in two tables. how can you join
- 5 Answers
- 11530 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / sbvp
by using union t/r
other wise create one dummy column in two tables
than join the two table with jioner t/r
ok
| Is This Answer Correct ? | 13 Yes | 4 No |
Post New Answer View All Answers
Which transformation should we use to normalise the COBOL and relational sources?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
As union transformation gives UNION ALL output, how you will get the UNION output?
What is the sequence generator transformation in informatica?
How can repository reports be accessed without sql or other transformations?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is informatica? Why do we need it?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is repository manager?
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
Explain the shared cache and re-cache?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
what is the complex transformation you used in informatica
explan ur project architecture?
