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;

What is a rank transform?

670

---

What are the different types of repositories created using informatica?

651

---

Enlist the advantages of informatica.

624

---

Explain what is informatica metadata and where is it stored?

602

---

In warehouses how many schemas are there?

577

---

---

Explain in detail about scd type 1 through mapping.

582

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1177

---

Explain how many types of dimensions are available in informatica?

590

---

Where is metadata stored?

616

---

What is parallel processing in informatica?

1023

---

Explain dynamic target flat file name generation in informatica

642

---

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1462

---

What are active transformations.

1184

---

I have a flat file, want to reverse the contents of the flat file

686

---

How can we use mapping variables in informatica? Where do we use them?

616

---