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
- 8713 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
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
server hot-ws270 is connect to Repository B. What does it mean?
can we override a native sql query within informatica? How do we do it?
What are the differences between oltp and olap?
Explain the aggregator transformation?
What is native users?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is the difference between a repository server and a powerhouse?
How might you approve all mappings in the archive all the while?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Explain the different dimensions.
If informatica has its scheduler why using third party scheduler?
What is the need for an etl tool?
What are the types of schemas we have in data warehouse.
Explain load alternative records / rows into multiple targets - informatica
