SOURCE
1 a
1 b
1 c
2 a
2 b
2 c
TARGET
1 A B C
2 A B C
In oracle & informatica level how to achieve
Answers were Sorted based on User's Feedback
Answer / mr.lee
Hi,
Using Informatica
SRC-SQ-SRT(key used id)-EXP(
v_name = IIF(ID=v_prev_id,v_prev_name ||'
'||UPPER(name),UPPER(name))
v_prev_name = v_name
out_name = v_prev_name
v_prev_id = ID
)-AGG(group by id will give u last row)-TGT
Ankit Kansal
This is wrong Concept....
First Try You
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / parikhita prusty
first sort the first column empid using sorter t/r then
expersion t/r create variable port
v_ename:=iff(prev.empid=curr.empid,v_ename||' '||ename,ename)
o_ename=v_ename
then using expersion t/r convert lower case higher case. any
doubt mail me.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ankit kansal
Hi,
Using Informatica
SRC-SQ-SRT(key used id)-EXP(
v_name = IIF(ID=v_prev_id,v_prev_name ||' '||UPPER(name),UPPER(name))
v_prev_name = v_name
out_name = v_prev_name
v_prev_id = ID
)-AGG(group by id will give u last row)-TGT
Using Oracle
select value from (
select id ||' '||upper(name) ||' '|| lead(upper(name),1) over (partition by id order by id) ||' '|| lead(upper(name),2) over (partition by id order by id) value from ankit_temp order by 1
)temp where length(value)>0 order by value;
http://deepinopensource.blogspot.com/
Is This Answer Correct ? | 1 Yes | 2 No |
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
Which is the t/r that builts only single cache memory?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
Global and Local shortcuts. Advantages.
Different circumstance which drives informatica server to expel records?
what is the complex transformation you used in informatica
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
When do you use sql override in a lookup transformation?
Could any one to tell Fact table Partitioning?
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com