Answer Posted / dilip ingole

using SQL

SELECT SUBSTR('101 a 101 b 101 c',1,4) ID ,REPLACE(TRANSLATE('101 a 101 b 101 c','1234567890',' '),' ','') DATA FROM DUAL;

Explain pushdown optimization and types in informatica

1015

---

what is $$$$?

2097

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7114

---

Explain pmcmd command usage in informatica

1065

---

What is a repository manager?

1029

---

Where is metadata stored?

1042

---

How an expression transformation differs from aggregator transformation?

989

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2075

---

Why update strategy and union transformations are active? Explain with examples.

1173

---

How many ways a relational source definition can be updated and what are they?

952

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2020

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1926

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1985

---

What is target designer and target load order?

1051

---

Explain dynamic target flat file name generation in informatica

1007

---