Answer Posted / srikanth nallapati

if we are not using group by also u get the result from agg
traceformation but u get only one one total column result

Ex:deptno sal
10 1000
20 3000
30 4000
10 5000
in aggr trance i am not use group by but i create one new
column like sum_of_sal here logic implementation is sum(sal)
this sum sal is linked with target table then u get result
as like above description.... if u try to send more then
one column from this aggre tranc means it's fail..

i think it's work....

Enlist the tasks for which source qualifier transformation is used.

980

---

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

1804

---

What is session task and command task?

1174

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2180

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2251

---

Define sessions in informatica etl?

964

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2055

---

In how many ways we can create ports?

1066

---

How big was your fact table

1743

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1995

---

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?

9968

---

What are roles and groups and benefits of using them?

988

---

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

1841

---

What are the data movement modes in informatica?

1080

---

what is INFORMATICA TESTING process

2224

---