Answer / koti

in correlated query is nothing but a sub query, but the difference is sub query can executes first, based on the result the main query executes...

Answer / ramesh

correlated view is a top down approch

Explain joiner transformation in informatica

0 Answers   Informatica,

---

How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?

10 Answers   Wipro,

---

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,

---

Two different admin users created for repository are ______ and_______

1 Answers  

---

My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000

3 Answers   TCS,

---

A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers  

---

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

---

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

4 Answers   HP,

---

How do you take care of security using a repository manager

2 Answers  

---

explain one complex mapping with logic? sales project?

0 Answers   Accenture, JPMorgan Chase,

---

In joiner, how to load Master table in Target?

2 Answers  

---

How to improve the performance of Aggregate transformation?

3 Answers   Dmss,

---