Answer Posted / sbvprasad

V1=iif(not isnull (id),id,v1)

for the 1st record.
V1= iif( not isnull (101), then pass 101).
now the V1 variable having the value = 101.

2nd record
V1= iif( not isnull ( null), then pass else condition V1 (
having 101 ))
now the V1 variable having the value = 101.

3rd record
V1= iif( not isnull ( null), then pass else condition V1 (
having 101 ))
now the V1 variable having the value = 101.

After applied the above logic we will get the output as
mentioned below.
-------------
ID NAME
--- ------
101 PANKAJ
101 KUMAR
101 MATHUR
102 JYOTI
102 SAXENA
103 SACHIN
102 TENDULKAR

2.In the next step take the aggregator transformation and
group by on the id. Then you will get the result.

TARGET TABLE
-------------
ID NAME
--- -------
101 PANKAJ KUMAR MATHUR
102 JYOTI SAXENA
103 SACHIN TENDULKAR

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?

913

---

What are the databases that informatica can connect to windows?

1000

---

What are the different types of repositories created using informatica?

1059

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1422

---

Explain sql transformation in script mode examples in informatica

1044

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1726

---

Differentiate between sessions and batches?

962

---

list out all the transformations which use cache?

1111

---

how to load rows into fact table in data warehouse

1114

---

What is informatica? Why do we need it?

1038

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1994

---

difference between repository database and repository service?

1080

---

What is the surrogate key?

1145

---

How can we create index after completion of load process?

1070

---

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

2063

---