Answer / mike

session override is an option in informatica at session
level. Here we can maually give an sql query which is
issued to the database when the session runs. It is nothing
but over riding the default sql which is generated by a
particular transformation at mapping level.

correct me if i was wrong

Answer / guduri

i think mike is correect

How the dimensions will be loaded?

0 Answers   HCL,

---

what is degenerated dimension table with scenario

2 Answers   HCL,

---

What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,

---

can anyone suggest best free Talend data integration training online

0 Answers  

---

What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,

---

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,

---

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

3 Answers   HP,

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

0 Answers  

---

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  

---

what is the diff b/w union and joiner and lookup?

4 Answers  

---

What are the differences between source qualifier and joiner transformation?

0 Answers  

---

Can we get 1st record through Informatica(without sequence number).

0 Answers  

---