Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 10101 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
What is main use of mapplet?
How can you validate all mappings in the repository simultaneously?
How many dimensions are there in informatica?
What do you mean incremental aggregation?
What is the difference between a connected look up and unconnected lookup?
Describe the impact of several join conditions and join order in a joiner transformation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Why is sorter an active transformation?
How are indexes created after completing the load process?
what is the Default Source Option For Update Strategy Transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is parallel processing in informatica?
Differentiate between router and filter transformation?
What all are steps in up gradation of Informatica server?
What is the benefit of partitioning a session?
