Answer Posted / nidhi

yes,Using stored procedure t/r we can do that..

I can give u brief idea.. i didnt tried this, sorry if it
goes wrong..

while writing the SP in oracle,we will call n execute the
existing sequence using execute immediate clause..
The o/p port of the SP t/r will be mapped to the sequence no
column in the target.


If i am wrong let me knw.. Thank you

What is the need of etl tools?

1052

---

To import the flat file definition into the designer where should the flat file be placed?

1004

---

What is xml source qualifier transformation in informatica?

1175

---

Explain what is informatica metadata and where is it stored?

987

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5561

---

What is substr in informatica?

1134

---

Clarify the aggregator change?

970

---

Explain why we use partitioning the session in informatica?

1006

---

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?

1429

---

How does a rank transform differ from aggregator transform functions max and min?

1144

---

Explain the informatica workflow?

1000

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1974

---

COM components can be used in Informatica

2312

---

How many ways a relational source definition can be updated and what are they?

952

---

what is the -ve test case in your project.

2329

---