saibabu

 Profile Answers by saibabu 

• Jan 11th, 2007

 

hi , every time creating a column in the target table , when a record exist in the sourse definition is deyond the scope of datawarehouse.why because the target table metadata is created only once and stored in the repository.when ever a workflow runs, the power center server reads required metada from the repository and completes the workflow .otherwise study the records in the source ,according to this change the metadata of target in the repository .which is not at all recomended.why because in oltp system every day transactions are goin on ,doing so is impossible.

sambawipro

 Profile Answers by sambawipro 

• Feb 15th, 2007

 

Hi , By Using normalizer transfermation we can pivot the rows.Thanks Samba

superhero

 Profile Answers by superhero Questions by superhero

• Dec 7th, 2008

 

by using normalizer,and also need to give the occurences and GCID and GK values.

abraham deng stephen

• Jul 3rd, 2013

 

Simple use expression transformation and make all the inputs into the date format given. Add a condition like

Code
 

This is my idea. It helps you hopefully....thx

priyank_divya

 Profile Answers by priyank_divya 

• Aug 28th, 2013

 

1. Sort based on ename column.
2. in Exp,
Var_Prev=Var_Curr
Var_curr=ename
Var_Value=IIF(Var_Prev=Var_Curr,Var_Value||,||payments,payments)
Out_Value=Var_Value
3. Aggregator transformation: Pull ename,Out_Value ports from Exp in Step 2.
Group by ename

Hope this helps!!!