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 are roles and groups and benefits of using them?
What is joiner transformation in informatica?
How can you join two tables without any common column present in them?
What is the benefit of partitioning a session?
What is query panel?
how will you get 21 to 30 record from 50 records?
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
why u go for dimensions ?
Can you use flat files in Mapplets.
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
Explain the different kinds of facts.