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 / ankit kansal
please elaborate your question...
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is the use of an aggregator cache file?
Explain your project of banking domian.
What are the different clients of powercenter?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is the difference between writing a joiner query in ANSI style and THETA style?
How to elaborate powercenter integration service?
Can we create two repositories on same database instance in oracle?
How do you take back up of repository?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How to start a workflow using pmcmd command?
In development project what is the process to follow for an etl developer from day1
what is Active lock explain
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is the difference between router and filter?
Write the different tools in the workflow manager?