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.
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 |
1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?
6 Answers CTS, HCL, IBM, Wipro,
Define data aggregation?
How to lode data in sequntional files perform faster?
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
What are datastage sequences?
Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5
ename like ibm,tcs,hcl need display those records only how?
What is the use of hoursfromtime() function in transformer stage in datastage?
Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari
How will you move hashed file from one location to another location?