in sequtial file 2 columns avaliable,iwant only one column load the target how

Categories >> Software >> Data Warehouse >> Data Stage
Suggest New Category

in sequtial file 2 columns avaliable,iwant only one column
load the target how do it.

Question Posted / guest

10 Answers
16332 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

in sequtial file 2 columns avaliable,iwant only one column load the target how do it...

Answer / babloo

inspite of all you can use the copy stage and simply map
the required column to the output.

Is This Answer Correct ?

16 Yes

0 No

in sequtial file 2 columns avaliable,iwant only one column load the target how do it...

Answer / ashok

we can do it using copy or modify, using the copy is better
bcoz it gives the performance

Is This Answer Correct ?

13 Yes

0 No

in sequtial file 2 columns avaliable,iwant only one column load the target how do it...

Answer / siva

good answer is
using copy stage because of performance wise
other wise
u can also use
xfm,modify stages

Is This Answer Correct ?

6 Yes

0 No

in sequtial file 2 columns avaliable,iwant only one column load the target how do it...

Answer / vinay kumar

using the modify stage, we can do.

Is This Answer Correct ?

5 Yes

0 No

in sequtial file 2 columns avaliable,iwant only one column load the target how do it...

Answer / radhakant kumar

you can use unix command in sequential file or in
transformer stage u can do this in sequential firl u will
get filter option there u can use (cut comand to cut
particular columns)

Is This Answer Correct ?

3 Yes

0 No

in sequtial file 2 columns avaliable,iwant only one column load the target how do it...

Answer / yarramasu

sorry for the above answer we can not use merge stage we
can use modify stage and drop unwanted columns and we can
also use transformer stage in this stage we have to do
which columns do u want that columns only u can drag from
source to target sorry for above answer

Is This Answer Correct ?

3 Yes

0 No

in sequtial file 2 columns avaliable,iwant only one column load the target how do it...

Answer / sravanthi menam

performance wise use copy or modify stage(Keep column).
Transformer also we can use

Is This Answer Correct ?

2 Yes

0 No

in sequtial file 2 columns avaliable,iwant only one column load the target how do it...

Answer / ritesh kumar chatterjee

Use Copy Stage and drag and drop the required columns @target

Very Easy way :)

Is This Answer Correct ?

0 Yes

0 No

in sequtial file 2 columns avaliable,iwant only one column load the target how do it...

Answer / sai

we can do it many ways.
But performance wise copy stage is good.Merge stage also
quite ok.

Is This Answer Correct ?

0 Yes

2 No

in sequtial file 2 columns avaliable,iwant only one column load the target how do it...

Answer / yarramasu

we can use merge stage and drop unwanted columns and we can
also use transformer stage in this stage we have to do
which columns do u want that columns only u can drag from
source to target

Is This Answer Correct ?

0 Yes

8 No

Post New Answer