I have the source like
col1 col2
a l
b p
a m
a n
b q
x y
How to get the target data like below
col1 col2
a l,m,n
b p,q
x y
Answers were Sorted based on User's Feedback
Answer / venky
src->sorter->exp->agg->tgt
sorter:-
select col1 key as sorter
exp:-
var1=iff(var2=col1,var1||','||col2,col2)
var2=col1
output_port=var1
agg;-
select group by col1
tgt:-
connect to target
Is This Answer Correct ? | 5 Yes | 4 No |
Answer / hanan
src->exp->agg->tgt
src:-
In sql query write order by col1
exp:-
col1->
col2->
var_col2=iif(col1=var_col1,var_col2||','||col2)
var_col1=col1
output_port=var_col2
agg;-
select group by col1
tgt:-
connect to target
Is This Answer Correct ? | 0 Yes | 0 No |
what is runtime variable?
What is the capacity of power cube?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
r u done any partitions in ur project?
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
What is the role of informatica in project ?Like i showed financial projects?
we have to use order by,where,having we to implement sql query
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
What is the cumulative sum and moving sum?
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.