Answer Posted / raghava

data one;
input number 10.;
datalines;
10
11
12
13
14
15
16
17
18
19
20
;
run;
data two;
set one;
if mod(number,2)=0 Then A=number; else B=number;

/* number=mod(number);*/

run;

Clarify the utilization of aggregator cache record?

983

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1260

---

What are the settings that you use to configure the joiner transformation?

1037

---

What is an active transformation?

1075

---

Explain in detail scd type 2 through mapping.

1025

---

EXL informatica Questions

1358

---

What does command task mean?

1115

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7012

---

Briefly describe lookup transformation?

1030

---

What are the popular informatica products?

998

---

can we override a native sql query within informatica? Where do we do it?

1096

---

What is the Process to creating lookup transformation in informatica

1031

---

What are junk dimensions?

1056

---

What if the source is a flat-file?

1089

---

How you can differentiate between connected lookup and unconnected lookup?

1045

---