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
- 10110 Views
- Polaris, Zensar, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / babu
what about ENO AND ENAME VALUES,
its should be old values or new values?
please give your output data sample exactly what you need.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rajesh aitha
We should ask a question here, do u want the location appended or the rest of the field appended to target if a record with same location is arrived next time?
sort based on location, Next use the logic in expression transformation to check the previous record location and next record location, if same then out put the concatenated values with first answer logic as explained here. Apply the same if required for rest of the fileds.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krishna
This is wrong question.please explain question with right
information
| Is This Answer Correct ? | 0 Yes | 2 No |
Which one is better performance wise connected/un-connected lkp?why?
How to load data in informatica ?
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
If I am having 6 flat files in data. How can you load the data at a time
write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How informatica process data means how informatica works?
What are the methods for creating reusable transforamtions?
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?
Explain the scenario which compels informatica server to reject files?
HOW TO DELETE A RECORD FROM FLAT FILE
Teradata 
