Answer Posted / suneel reddy

Answers 1:
Depending upon the scenario we use the conn and unconn tr..

for e.g
In u r mapping u require same lkp multiple times, creating
lkp multiple times put it in flow is not a good idea, which
occupies more cache ...
Instead of that create one unconnectes lkp use multiple
times where ever u want , which very fast..

Answers 2:
u can use conn lookup but if u need 1 row so go for unconn
lookup coz u can
use it multiple time in same mapping from multiple
expression trn.
i hope it will help to u

What is a predefined event?

1032

---

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

1574

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6910

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1267

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1197

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2053

---

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1805

---

Explain load alternative records / rows into multiple targets - informatica

1099

---

what is size of u r database?

2246

---

What is meant by query override?

1005

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1727

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1031

---

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

2064

---

Briefly describe lookup transformation?

982

---

Explain sql transformation in script mode examples in informatica

1046

---