Answer Posted / keshav

CREATE AN EXPRESION TALE 2 VARIABLE AND 2 OUTPUT PORTS

FOR VARIABLE PORTS WRITE THE BELOW EXPRESSIONS

V_NAME(v)=IIF((IIF(ISNULL(ID),V_ID,ID)=V_ID),V_NAME || ' ' || NAME,NAME )

V_ID(v)=IIF(ISNULL(ID ) , V_ID, ID )

OUT_ID(o)=V_ID
OUT_NAME(o)=V_NAME

AFTER TAKE AGGREGATER AND SELECT OUT_ID AS GROUP BY PORT

AFTER CONNECT TO TARGET

How to open an older version of an object in the workspace?

1264

---

What is informatica?

1218

---

What does refresh system mean, and what are its distinctive choice?

1271

---

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

1170

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1676

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2186

---

What is meant by query override?

1113

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2121

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1250

---

What is fact table? Explain the different kinds of facts.

1123

---

What are the various types of transformation?

1239

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

2249

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3755

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1187

---

What is Cognos script editor?

4286

---