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
- 10308 Views
- Polaris, Zensar, I also Faced
- E-Mail Answers
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
Explain what is informatica metadata and where is it stored?
What is the difference between source qualifier transformations source filter to filter transformation?
What are the modules in Power Center
How do you use reject loader.
Explain in detail scd type 2 through mapping.
What is different between the data warehouse and data mart?
Which development components of informatica have the highest usage?
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
I have a flat file, want to reverse the contents of the flat file
Why update strategy and union transformations are active?
Explain the types of lookup transformation?
Differentiate between sessions and batches?
What are batches?
What is Cognos script editor?
What is flashback table ? Advance thanks
