Answer Posted / deepu

To load 5 differnt files of same format .first creat a
directory in Unix and copy all the file into this directory
and using the option as Indirect load in session properties
give the loaction of unix in source and it will enable to
load all the 5 files in single run in to a target . if we
have 5 diff files in 5 different formats then firstly
convert all in to one format and then proceed as explained
aboue.

What are the mapping parameters and mapping variables?

1210

---

How to create the source and target database connections in server manager?

1094

---

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

---

What is resilience time?

1151

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2166

---

Is it possible to use a client with different version than that of its Informatica server?

1152

---

Explain the different dimensions.

972

---

How to do the error handling of if ur source is flatfiles?

1972

---

If informatica has its scheduler why using third party scheduler?

1271

---

EXL informatica Questions

1396

---

What do you understand by a term domain?

1129

---

What are the issues you have faced in your project? How did you overcome those issues?

2366

---

What is a passive transformation?

1110

---

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,

7188

---

How do you convert single row from source into three rows into target?

1162

---