1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

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

How to differentiate between the active and passive transformations?

621

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

546

Different qualification between a related rotate toward the sky and isolates look upward?

549

What is confirmed fact in dataware housing?

5671

How can we update a record in the target table without using update strategy?

650




What is the status code in stored procedure transformation?

683

How to generate or load values in to the target table based on a column value using informatica etl tool.

605

Please let me know how to make encryption and decryption with example?

1460

is it possible to index the data in cache of lkp transformation ?

1520

What are the different versions of informatica?

672

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1780

When do you use sql override in a lookup transformation?

580

What are the performance considerations when working with aggregator transformation?

674

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1527

what is the complex transformation you used in informatica

2185