Answer Posted / pawan

With the batch file , we can run sessions either in sequential or in concurrently.

Grouping of Sessions is known as Batch.

Two types of batches :
1)Sequential: Runs Sessions one after another.
2)Concurrent: Run the Sessions at the same time.


If u have sessions with source-target dependencies u have to go for sequential batch to start the sessions one after another. If u have several independent sessions u can use concurrent batches Which run all the sessions at the same time.

Different circumstance which drives informatica server to expel records?

1040

---

Suppose we do not group by on any ports of the aggregator what will be the output?

1096

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1119

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

1017

---

How many ways are there to do 'remove duplicate records in informatica'?

1062

---

What is meant by active and passive transformation?

1189

---

Explain lookup transformation is active in informatica

1146

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2248

---

Write the different tools in the workflow manager?

1112

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2168

---

What is a rank transform?

1145

---

Global and Local shortcuts. Advantages.

2085

---

What are mapplets?

1324

---

What are data-driven sessions?

1258

---

Explain Dataware house architecture .how data flow from intial to end?

2644

---