DataStage - How to connect two stages which do not have any common columns between them?

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 332 of 380

How to connect two stages which do not have any common columns between them?

Total Answers and Comments: 3

Last Update: February 22, 2008 Asked by: Praveen

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

September 18, 2007 06:18:45

prasoon.pandey

Member Since: August 2007 Contribution: 2

RE: How to connect two stages which do not have any co...

If suppose two stage don’t have the same column name then in between use one Transformer stage and map the required column.

Is this answer useful? Yes | No

February 12, 2008 04:49:44

manoharkolukula

Member Since: January 2008 Contribution: 32

RE: How to connect two stages which do not have any common columns between them?

Hi,

First of all tell me those are stages or sources.

If those are sources then u better use copy stage after one stage and change the column name according to ur requirement , then join these two sources.

If it is oracle database then select the user def sql, there u put alias name and change the col name by selecting the columns tab.

Is this answer useful? Yes | No

February 22, 2008 05:50:35

Amritendra kumar

Member Since: February 2008 Contribution: 16

RE: How to connect two stages which do not have any common columns between them?

In both stage create one extra port and assign the value of those port is 0 then join it.
but best option is allready suggested that use Transformer stage and map required column.

Is this answer useful? Yes | No

Go To Top