if we have input eno 1,2,3,1,2,3 year
2001,2002,2003,2001,2002,2003 and sal
10000,20000,30000,20000,30000,40000
ex-output
eno totsal
1 30000
2 50000
3 70000
- 7 Answers
- 7741 Views
- I also Faced
- E-Mail Answers
Answer Posted / narendra
in source qulifier we override query like this
select eno,sum(sal as totsal)from emp group by eno
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
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 are the settings that you use to configure the joiner transformation?
can anyone suggest best free Talend data integration training online
waht type of interface is used for testing the data in informatica
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is data movement mode in Informatica and difference between them?
Explain the code page compatibility?
How are indexes created after completing the load process?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is the use of an aggregator cache file?
Informatica Checkpoints
Define filter transformation?
How we can create indexes after completing the loan process?
What is informatica? Why do we need it?
What is the use of target designer?
