src_qlr--> sorter(on basis of location)->expression in exp there wil

I am having source
ENO ENAME LOC
1 A PUNE
2 B MUMBAI
3 C CHENNAI
Target
ENO ENAME LOC
1 A PUNE
2 B MUMBAI
3 C CHENNAI
If a new record coming from source from same location it should directly go to specified location in target at begining
EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

Question Posted / govind

5 Answers
10324 Views
Polaris, Zensar, I also Faced
E-Mail Answers

Answer Posted / govind

src_qlr--> sorter(on basis of location)->expression
in exp there will be following ports
1)ENO(I/O)
2)ENAME(I/O)
3)LOC(I/0)
4)V_LOC(VARIABLE PORT) = IIF(LOC = V_PREV_LOC,V_LOC || '|' || LOC,LOC)
5)V_PREV_LOC(VARIABLE PORT) = LOC
6)O_LOC(O/O PORT) = V_LOC
now connect this exp to targert
as
eno to eno
ename to ename
o_loc to loc

Is This Answer Correct ?

3 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Write the advantages of partitioning a session?

1289

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2366

Mention few advantages of router transformation over filter transformation.

1028

explan ur project architecture?

2075

What is depict expression change?

1130

What are the measure objects?

1213

What is union transformation in informatica?

1154

what are 3 tech challenges/ common issues you face?

2350

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

9152

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1301

can we override a native sql query within informatica? How do we do it?

1132

Is it possible to create multiple domains on a single Informatica server?

1251

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2268

What is Data Caches size?

1098

What is primary and backup node?

1138