Answer Posted / srinivas

Joiner is to join two different sources .If u use Update
strategy T.F and trying to use DD_delete&DD_reject option
the some of the data will get deleted and u can't see the
at joiner output.
So we can't go for this .

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1002

---

Explain lookup transformation in informatica

1007

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2509

---

Explain the etl program with few examples.

968

---

What is informatica metadata and where is it stored?

935

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2077

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

992

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1076

---

To import the flat file definition into the designer where should the flat file be placed?

1008

---

How many number of sessions can one group in batches?

1097

---

What is a stored procedure transformation?

993

---

Make a note of the quantity vaults made in informatica?

945

---

can u give example for factless fact table

6447

---

What is incremental aggregation?

1017

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1578

---