Answer / sukanta

The interviewer just check your knowledge about Informatica
Lookup Transformation.

If you disable cache you can't override the default sql query.

Follow Informatica Help.

Regards
Sukanta

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

0 Answers   Informatica,

---

What is a shortcut and copy in Informatica and how two are different with each other?

0 Answers  

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

0 Answers   TCS,

---

can any one explain me about junk dimension

4 Answers  

---

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

---

How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,

---

I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,

---

What is difference between a gateway node and worker node?

0 Answers  

---

How do you implement configuration management in Informatica?

1 Answers  

---

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,

---

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers  

---

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,

---