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
- 9057 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 domain in terms of informatica?
wat are deployement groups in informatica, how it will be used for developers
What is a connected transformation?
What is sorter transformation?
What are the types of lookup transformation?
What happens when a session fails and you click on recover?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Which development components of informatica have the highest usage?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
whats the logic to load the lower level of granularity of data to fact table.
What is an expression transformation?
What do you mean by worklet?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What are the tasks that can be performed using sq?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
