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
- 9054 Views
- Polaris, Zensar, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the prerequisite tasks to achieve the session partition?
What are the advantages of informatica?
What is Session and Batches?
Which development components of informatica have the highest usage?
What is the surrogate key?
What do think which one is the better joiner or look up?
What is the use of an aggregator cache file?
How many ways are there to do 'remove duplicate records in informatica'?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is meant by target load plan?
Clarify the aggregator change?
How would you copy the content of one repository to another repository?
What is a joiner transformation?
Define mapping and session?
What are the different types of repositories created using informatica?
