How to Map N number of columns from input to output schemas at a time?

[Former Member]

Hi,

I am new to BODI. In my project we are using DAT files, which contains more than 100 columns, as Source. At the Data Flow Level, in Query Transformation we are manually mapping columns from INPUT Schema to OUTPUT Schema one by one.

Is there any way to MAP all the columns at a time from INPUT schema to OUTPUT schema.

Hope I am clear with my question.

Thanks for your support.

--

Sudhakar

[Former Member · Accepted solution]

I am not sure if I understand your question correctly. If you e.g. want to map all columns from the left hand side to the right hand side you can select the first record on the left hand side, hold the shift key, press the down key, and while holding the shift key, drag all of them over to the right hand side.

If you want to select/unselect individual columns, you can hold the ctrl key and click the columns with the mouse.

I hope that helps.

[Former Member · Accepted solution]

Hi,

Thanks for your answer.It's really helpul.

But in my case, Source Filed names and Target Field names are different. As we know, OUTPUT column names should be same as Target Field names.

I am just wondering is there any option to MAP columns between INPUT schema and OUTPUT Schema at a time, like Informatica.

In Informatica you can MAP all the columns at a time between any 2 Transformation by using their port order, even though the Filed names are different .

Do we have any option like this in BODI?

Regards,

Sudhakar

[Former Member · Accepted solution]

What is possible is that if the schema (types, length) is the same on both sides and the order is the same you can just connect both of them (without even introducing another transform or query) and BODS maps to the output accordingly.

[Former Member · Accepted solution]

Thanks a lot my friend