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 / 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 do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Explain the types of transformations?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What do you mean by channel change?
How can you differentiate between powercenter and power map?
What is a repository? And how to add it in an informatica client?
What is data caches/ index caches?
What is difference between a gateway node and worker node?
What is the meaning of up gradation of repository?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is repository manager?
What is the maplet?
What is target load order?
What is the function of look up transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.