Answer / mahesh

In the Fallowing Situations we use Sequence Generator
Transformation
1)Creating Primary Key Values
2)Replacing The Missing Key Values
3)When You Apply the Cycle Through a Sequential Range Of
Numbers

Answer / purva

Create keys.
Replace missing values.
Cycle through a sequential range of numbers

Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?

4 Answers  

---

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

---

In which scenario did you used pushdown optimization?

1 Answers  

---

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  

---

Do you have knowledge in ralph kimball methodology

1 Answers  

---

Briefly define reusable transformation?

0 Answers  

---

What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

2 Answers   IBM, Wipro,

---

What is degenerated dimention table?

7 Answers   Patni,

---

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,

---

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers  

---