Interested to Buy Any Domain ? << Click Here >> for more details...
I have a file it contain 2 records like empname,company as
Ram, Tcs and Ram, IBM. But i want empname,
company1,company2 as Ram, TCS,IBM in the target. How?
- 6 Answers
- 14375 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
The Simple way is:
SRCFile---->PIVOT Stage---->TGT
1. in PIVOT stage, select vertical PIVOT option.
2. specify the 'Array Size' as 2
3. select the 'Group by' check box for 'empname'
4. select the 'Pivot' check box for 'company'
then u will get the desired output.
| Is This Answer Correct ? | 11 Yes | 1 No |
The flow will be like this
src----->sorter---->transformer----->remove duplicates---->trg
SORTER
in sorter sort by the key=empname and create keychange column
TRANSFORMER
create two stage variables stg1 and stg2
if key change=1 then company else stg2 :',': company |stg1
_____________________________________________________|_____
|
stg1 |stg2
connect the stg1 as out put column and empname as output
from transformer connect to the remove duplicates
REMOVE DUPLICATES
key=empname
duplicates to retain=last
connect to the trg
u will get the output
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / cgi
Take sequential file and use sort stage and set keychange
column=true,put filter to output the data to two links, one
is kechange is 0 and other is for 1. first link is directly
goes to join stage and other stage should go to copy
stage.In the copy stage change the company column name to
company2 and populate to join. in the join stage provide
the key column to 'name' and do inner join. u will get
output as required.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / tina
Use a lookup stage after the file. Do a self-lookup on this
file on empname. When the empname matches, take the empname
and company1 from stream link and company2 from reference
link and map to the target.
| Is This Answer Correct ? | 1 Yes | 4 No |
Venkatesh is Absolutely right but unfinished. After remove
duplicate stage we have to use either column import stage or
transformer stage.
SEQ>>>TRANS>>>REMOVEDUPLICATE>>>COLUMNIMPORT/TRANSFORMER>>>TARGET
if Transformer: use field function in derivation
for company1: field(company,',',1)
company2: filed(company,',',2)
for column import stage: specify the key column: company
default delimeter: ','
columns: company1 and company2
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / murali
Take the seq file stage and transformer and data set. in
transformer stage take two stage variables st1,st2 set the
intial value as '0' and data type is 'varchar' for st1
in st2 by using concatenate st1:',':st2
| Is This Answer Correct ? | 0 Yes | 12 No |
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What are orabulk and bcp stages?
How can we run same job in 1 day 2 times
Explain the situation where you have applied SCD in your project?
Explain how a source file is populated?
job locking methods? How can we unlock the job?
input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2
How to remove blank spaces from data?
How To find the location of APT_confid file
What is process model?
What is the difference between lookup and sparse lookup?
1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?
Teradata 
