without matching columns in two tables. how can you join
Answer Posted / sbvp
by using union t/r
other wise create one dummy column in two tables
than join the two table with jioner t/r
ok
| Is This Answer Correct ? | 13 Yes | 4 No |
Post New Answer View All Answers
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Write the prerequisite tasks to achieve the session partition?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is main use of mapplet?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
can anyone explain me about retail domain project in informatica?
Differentiate between sessions and batches?
permutations of mapplet
What is the way to execute pl/sql script using informatica mapping?
What is InformaticaPowerCenter?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what is the complex transformation you used in informatica
What are Dimensional table?
write a query to retrieve the latest records from the table sorted by version(scd)