Answer / amedela chandra sekhar

Presql :sql statement executed before the session retrive
the data from source.
Postsql:sql statement executed atfer the session retrive the
data from source.

what is mystery dimension?

1 Answers  

---

what is confirmed dimension?

6 Answers  

---

can we override a native sql query within informatica? How do we do it?

0 Answers  

---

what is semi-additive fact?where did u used?

2 Answers  

---

what is bridge tables in informatica

1 Answers   CTS,

---

How to start a workflow using pmcmd command?

0 Answers  

---

i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

1 Answers   Mind Tree,

---

,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

3 Answers   Emphasis,

---

What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,

---

What are the uses of etl tools?

0 Answers  

---

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

---