Answer Posted / jay

SCR-->SQ-->AGGR-----
| |
| v TRG 1
--------->RTR--> /
/ \
SEQ TRG 2

First get the count of records using Aggr t/r
and use this result in router t/r and have
router condition as SEQ < (Count / 2) for TRG 1
and default for TRG 2

What are the transformations that are not supported in mapplet?

1033

---

What is a grid in Informatica?

1072

---

Explain lookup transformation in informatica

1079

---

Make a note of the quantity vaults made in informatica?

988

---

How many types of sessions are there in informatica.please explain them?

1170

---

What are the types of caches in lookup? Explain them.

971

---

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1995

---

What is the sql query overwrite in source qualifier in informatica

1094

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1914

---

what are the Methods For Creating Reusable Transformations?

1177

---

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

1969

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2011

---

Explain in detail scd type 2 through mapping.

1045

---

What are the various types of transformation?

1181

---

what is diff b/t sorter t/r and agg have the option sorter property...

2181

---