by using union t/r other wise create one dummy column in two tables tha

without matching columns in two tables. how can you join

Question Posted / sbvp

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

Please Help Members By Posting Answers For Below Questions

Define mapping and session?

1088

Explain how many types of dimensions are available in informatica?

1169

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1327

Define update strategy?

1315

Define mapplet?

1058

In warehouses how many schemas are there?

1128

design of staging area?

2075

What is difference between a gateway node and worker node?

1202

How can a transformation be made reusable?

1229

Clarify the utilization of aggregator cache record?

1043

Explain what are the different versions of informatica?

1144

Why update strategy and union transformations are active? Explain with examples.

1284

What does reusable transformation mean?

1192

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2106

what is informatica metadata?

1088