How can you join two tables without any common column present in them?
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
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
can you please explain me pre session and post session options?
How many dimensions are there in informatica?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What are the new features of Power Center 5.0?
Describe expression transformation?
What are the different types of olap? Give an example?
Explain the shared cache and re-cache?
When do you use sql override in a lookup transformation?
What is lookup transformation?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is a predefined event?
What do you mean by blocking transformation?
what is index?how it can work in informatica