Answer Posted / priyank

PORT=INPUT("vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com"
VAR_EMAIL_1=SUBSTR(PORT,1,INSTR(PORT,',',1,1)-1)
VAR_EMAIL_2=SUBSTR(PORT,INSTR(PORT,',',1,1)+1,INSTR(PORT,',',1,2)-1)
VAR_EMAIL_3=SUBSTR(PORT,INSTR(PORT,',',1,2)+1)
VAR_NAME_1=SUBSTR(VAR_EMAIL_1,1,INSTR(VAR_EMAIL_1,'@',1)-1)
VAR_NAME_2=SUBSTR(VAR_EMAIL_2,1,INSTR(VAR_EMAIL_2,'@',1)-1)
VAR_NAME_3=SUBSTR(VAR_EMAIL_3,1,INSTR(VAR_EMAIL_3,'@',1)-1)
OUT_PORT=VAR_NAME_1||','||VAR_NAME_2||','||VAR_NAME_3

What is a repository manager?

1039

---

How do you migrate data from one environment to another?

1053

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7335

---

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

1819

---

What is Data Caches size?

1044

---

Explain the features of connected and unconnected lookup.

889

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2213

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2199

---

What is complex mapping?

1077

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1994

---

What is an expression transformation?

976

---

Define Pmrep command?

1004

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2087

---

what is INFORMATICA TESTING process

2242

---

Explain how to import oracle sequence into informatica?

960

---