How can you join two tables without any common column present in them?
Answer / 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 |
What is domain in terms of informatica?
Howmany ways yoU can update a relational source defintion and what are they?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain factlessfact table with scenario
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
what is the main advantage of unconnected lookup
When the informatica server marks that a batch is failed?
Explain what are the different versions of informatica?
Explain about Informatica server process that how it works relates to mapping variables?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are the types of schemas we have in data warehouse and what are the difference between them?