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

Repository user profiles

1768

---

Explain pmcmd command usage in informatica

1140

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1681

---

What is a pre-defined event and user-defined event?

1043

---

What are the static cache and dynamic cache in informatica?

1198

---

What is a surrogate key?

1089

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8204

---

How to extract the informatica rejected data?

1225

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2282

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1981

---

What is depict expression change?

1127

---

Explain sessions and how many types of sessions are there?

1013

---

What is meant by active and passive transformation?

1131

---

What is an aggregator transformation?

1101

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1085

---