Answer Posted / shrawan

select employee, salary from table_name
where
salary > ( select avg(salary) from table_name;

What is a sequence generator transformation?

1000

---

How might one distinguish in the case of mapping is right or not without associating session?

1083

---

Is it possible to create multiple domains on a single Informatica server?

1220

---

What are ETL Tools?

1098

---

Difference between Target-based loading and constraint-based loading?

983

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1492

---

Define sessions in informatica etl?

1012

---

What is aggregate cache in aggregator transformation?

1126

---

What are the types of presistent cache in look up tr.

2044

---

What is the difference between informatics 7x and 8x and what is latest version?

1071

---

Did u used latest transformations of 8.6.0? for what?

1870

---

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?

10123

---

what is the complex transformation you used in informatica

2579

---

What all join we can perform in LOOKUP transformation?

954

---

generate date / time dimension in informatica

1113

---