Answer Posted / amedela chandra sekhar

when you do session partitions ,session performance will be
increase.


ex : session running time 40 minutes before partition
session running time 10 minutes after partition

partition 5 types

key range
hash
pass through
round robin
database

let me if any wrong

chandumba2005@gmai.com

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1996

---

explan ur project architecture?

2005

---

What does update strategy mean, and what are the different option of it?

1035

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2306

---

Explain constraint based loading in informatica

1037

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1885

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2121

---

Explain the informatica workflow?

1000

---

What is rank transform?

941

---

What is main use of mapplet?

1070

---

What is the difference between a repository server and a powerhouse?

1413

---

While migrating the data from one environment to another environment how would you manage the connections?

1047

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6039

---

Can you generate sequence numbers without using the sequence generator transformation?

1050

---

What is an aggregator transformation?

1030

---