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
- 10457 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
What's the layout of parameter file (what does a parameter file contain?)?
What are active and passive transformations?
Briefly define a session task?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
explain one complex mapping with logic? sales project?
Is it possible to create multiple domains on a single Informatica server?
What is difference between a gateway node and worker node?
What is xml source qualifier transformation in informatica?
What is resilience time?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How union transformation is used?
What are the restrictions of union transformation?
What is the fact table?
tell me 5 session failure in real time how can you solve that in your project?
how we can load rejected record's at run time?(not through bad files)
