Answer / bala govi

I dont see there is a limit set for number of tasks that
you can have it in workflow/batch. but best practice is to
have less number of tasks this will help especially during
migration.

Answer / swetha

Any number of sessions.

Answer / ravi

At a time informatica server can execute 30 sessions
parallelly.

how do u move the code from development to production?

6 Answers  

---

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

1 Answers   IBM,

---

Explain pmcmd command usage in informatica

0 Answers   Informatica,

---

What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,

---

What are the different caches used in informatica?

3 Answers   UST,

---

Differnce between filter and router?

14 Answers   IBM,

---

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

---

How to extract sap data using informatica? What is abap? What are idocs?

0 Answers  

---

From where we can start or use pmcmd?

3 Answers  

---