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....

Differentiate between Load Manager and DTM?

2154

---

What are the types of caches in lookup?

1050

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1069

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1279

---

What is a surrogate key?

1083

---

What is rank transform?

998

---

how many types of dimensions are available in informatica?

1101

---

How we can use union transformation?

1051

---

I have a flat file, want to reverse the contents of the flat file

1128

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1270

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1283

---

whats the logic to load the lower level of granularity of data to fact table.

2276

---

What is a stored procedure transformation?

1056

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

2302

---