Interested to Buy Any Domain ? << Click Here >> for more details...
in sequtial file 2 columns avaliable,iwant only one column
load the target how do it.
- 10 Answers
- 16505 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.
what is the use of materialized view?
Which commands are used to import and export the datastage jobs?
Difference between server jobs & parallel jobs?
Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .
how many types of remove the duplicate records?
How many input links can you give to a Transformer stage?
Explain connectivity between datastage with datasources?
What are the steps needed to create a simple basic datastage job?
what is sparse lookup?
Name the third party tools that can be used in datastage?
HOW CAN U DO ERROR HANDLING IN DATA STAGE?
Teradata 
