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 |
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null
what are the different types of transformation available in informatica and what are the mostly used ?
What is the difference between view and materialised view?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
WHAT IS FACT TABLES?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
What is pmcmd command?
Enlist some properties of sessions.
how may sources can be used in a mapping at a time?(limit)
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
What are the reusable transforamtions?