Answer Posted / reddevilzz

For mapping parameters, there cud be a scenario as below
Lets say I have a sql override as ,
Select emp_no, emp_name from emp where $$Hint1
In parameter file, I have $$Hint1 = dept_id in (1,2)
if $$Hint = <empty>, in parameter file, in this case the
mapping will fail because, SQ would not be able to prepare
the query,

In another scenario, i can have SQ override as
Select emp_no, emp_name from emp $$Hint1
In parameter file, I have $$Hint1 = where dept_id in (1,2)
if $$Hint = <empty>, in parameter file,
still the mapping will be executed.

Where are the source flat files kept before running the session?

635

---

EXL informatica Questions

945

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

786

---

What is the benefit of session partitioning?

610

---

what is the size of u r source(like file or table)?

1831

---

---

What are the databases that informatica can connect to windows?

595

---

Describe the impact of several join conditions and join order in a joiner transformation?

656

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

644

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

553

---

Explain what is informatica metadata and where is it stored?

620

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1562

---

What are the tasks that source qualifier perform?

639

---

How many ways are there to do 'remove duplicate records in informatica'?

595

---

How can you define user defied event?

635

---

what are 3 tech challenges/ common issues you face?

1901

---