Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
I have 3 records,
1 Srini
1 vasa
2 reddy
now i want o/p like this
1 Srinivasa
2 reddy
could u please help in this
Thanks in advance.
- 6 Answers
- 12744 Views
- Teradata, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / madhavareddy
seqstage->sortstage->transformerstage->removedupicatestage->targetdataset
sortstage->put chagekeycolum=true
transformer -> stagevariable->sv1 if change key colum =1 then in.column else sv1::in.column
in derivation colum give ->sv1
then in remove duplicate stage keep last record option
then you will get desired output
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / prasad
MadhavaReddy, who gave logic that is correct.
I tried, got exact result.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gopal
In the transformer stage u can use concatination symbol for
first two records like Record1 : Record2 this is for first
column and second column u mentioned as it is.
| Is This Answer Correct ? | 6 Yes | 9 No |
Answer / radhakant kumar
hey it is just a example it could be like this..
1 Srini
1 vasa
1 aaaaa
the complete solution will be
say col1 and col2 so define stage variable in transformer
col1--------------->a(interger)
col2--------------->b(varchar)
if a=c then d:b else ''-->e(varchar)
e----->d(varchar)
a----->c(integer)
then in target pass e value to col2 and map col1 to col1
| Is This Answer Correct ? | 2 Yes | 5 No |
Answer / narayana kota
Hi
you can do this job using Pivot Stage convert these rows in
Columns by specify the column name in pivot stage as
first_column ,second_column and third_column and using
tranformer stage concatante first_column and second_column
using stage variables and pass to target.
if any method is there plz let me known
Regards
Narayana Kota
pnarayana12@gmail.com
| Is This Answer Correct ? | 2 Yes | 6 No |
Answer / satya
Make U r source file as SOURCE and LOOKUP Files then
Make lookup on key(in u r question first column),if u find
then concatination of u r source value and u r look up VALU
(Srini:Vasa)
| Is This Answer Correct ? | 1 Yes | 7 No |
what is difference between migration project and integration project? can anyone explain with the example Thanks in advance
What is the project in datastage?
What is the use of datastage designer?
how to transfer file from one system to another system in unix? which cmd to be use?
Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.
I have a few records just I want to store data in to targets cycling way how?
how can we join one oracle & flat files ?
Hi Vijay here For Four CPU's how many nodes will required?
Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?
What is the difference between validate and compile?
wt is the difference between swith and filter stage
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Teradata 
