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 tokens will generate?

2249

---

What is a surrogate key?

1153

---

explain about unit testing? in real time?

2265

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1799

---

expain about the tune parameters?

2457

---

State the limitations where we cannot use joiner in the mapping pipeline?

1106

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1125

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1817

---

What is a snowflake schema?

1047

---

Why do you use Mapping Parameter and mapping variable?

1807

---

Explain the different kinds of facts.

1020

---

What are the tuning techniques you applied during your last project

2075

---

Reusable transformation and shortcut differences

1880

---

What are the different lookup cache(s)?

1167

---

Can we create multiple integration service on single repository?

1240

---