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
- 10336 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 |
How to identify this row for insert and this row for update in dynamic lookup cache
What is meant by active and passive transformation?
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
What is parallel processing in informatica?
how do u move the code from development to production?
What is update override?
What are the basic needs to join two sources in a source qualifier?
In operator is used in which transformation in informatica 8.6.0
What is repository manager?
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
What is a design?
Can we get 1st record through Informatica(without sequence number).
Teradata 
