Answer Posted / ankit kansal

one solution can be like this


select max(q1) as q1,max(q2) as q2,max(q3) as q3,max(q4) as q4 from
(
select case when quarter = 'q1' then sales end q1
,case when quarter = 'q2' then sales end q2
,case when quarter = 'q3' then sales end q3
,case when quarter = 'q4' then sales end q4
,row_number() over ( partition by quarter order by 1 ) rnk

from sequel_test order by 5

)tb group by rnk order by 1,2,3,4

How many ways are there to do 'remove duplicate records in informatica'?

1015

---

What is a passive transformation?

1105

---

What happens when a session fails and you click on recover?

1120

---

What are the components of Informatica? And what is the purpose of each?

1055

---

Please let me know how to make Data masking in informatica..

1726

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1167

---

What is informatica?

1156

---

Explain sessions. Explain how batches are used to combine executions?

1034

---

How many ways a relational source definition can be updated and what are they?

1018

---

Write the advantages of partitioning a session?

1282

---

How to call shell scripts from informatica?

999

---

Define pmcmd command?

1047

---

can u give example for factless fact table

6651

---

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

---

Explain what are the different versions of informatica?

1099

---