How to jion 2 tables, without using any condition?
Answer Posted / balu024
use union transformation, if two tables having same meta data
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How to elaborate powercenter integration service?
What are the different ways to implement parallel processing in informatica?
What are the main issues while working with flat files as source and as targets ?
Describe expression transformation?
What are different types of transformations available in informatica?
what is song in infrmatica...?
What is the sql query overwrite in source qualifier in informatica
How to improve the performance of a session using sorter transformation?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is the way to execute pl/sql script using informatica mapping?
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.
Define enterprise data warehousing?
How can we delete duplicate rows from flat files?
What are the different options available for update strategy?