Answer Posted / davankumar

select name,sal,(select max(sal) from t1) from t1

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

1914

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2126

---

What is substr in informatica?

1209

---

What is an active transformation?

1111

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1063

---

generate date / time dimension in informatica

1126

---

What you know about transaction control transformation?

996

---

define galaxy repository in informatica

2229

---

Explain about cumulative Sum or moving sum?

1043

---

How can we store previous session logs?

1083

---

What is informatica metadata and where is it stored?

992

---

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2160

---

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?

1512

---

What is workflow? What are the components of workflow manager?

1178

---

how many types of dimensions are available in informatica?

1101

---