Interested to Buy Any Domain ? << Click Here >> for more details...
How can you join two tables without any common column present in them?
- 1 Answers
- 3773 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / lisa
I can add one dummy column to both the tables with value '1' and join both the tables on the basis of that dummy column. But how to do the join when there are huge number of columns/huge data volume in the tables? Please reply!
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the types of data warehouses?
How many input parameters can exist in an unconnected lookup?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What does role playing dimension mean?
What does “tail –f” command do and what is its use as an Informatica admin.
What is native users?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Which transformation is needed while using the Cobol sources as source definitions?
Explain lookup transformation source types in informatica
is it possible to index the data in cache of lkp transformation ?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is the use of source qualifier?
What is meant by incremental aggregation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is a node in Informatica?
