Answer / venubyna1

Lookup is better as compare to join
bcoz joiner does not supports to inequality but look
supports to inequality
and both r does not support OR condition

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

0 Answers  

---

can we use cartesian join in informatica

3 Answers   IBM,

---

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

---

Is there any way to read the ms excel datas directly into informatica?

0 Answers  

---

How do you load first and last records into target table?

0 Answers  

---

What is informatica?

0 Answers  

---

what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,

---

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

---

What are different types of transformations available in informatica?

0 Answers  

---

Name the different lookup cache(s)?

0 Answers  

---

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers  

---