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
Answer Posted / 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 |
Post New Answer View All Answers
What is an expression transformation?
What is standalone command task?
How to use procedural logic inside infromatica?
How many ways a relational source definition can be updated and what are they?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Differences between version 7.x and 8.x.
Is it possible to use a client with different version than that of its Informatica server?
Explain lookup transformation source types in informatica
What is meant by lookup transformation?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is workflow monitor?
What is union transformation?
What are the differences between source qualifier and joiner transformation?
What is enterprise data warehousing?