Informatica - hI,i am trying to use a flat file and using oracle table as a lookup. when i try to debug its advisi

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 72 of 300

hI,

i am trying to use a flat file and using oracle table as a lookup. when i try to debug its advising invalid mapping. can anyone please help me with this.

i also wrote the condition in the lookup as custid=custid.

the same is working if i have my source as oracle table.

thanks
nayana

Total Answers and Comments: 3

Last Update: September 13, 2006 Asked by: NAYANA

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

September 12, 2006 09:30:30

Motilal

Member Since: June 2006 Contribution: 13

RE: hI,i am trying to use a flat file and ...

You please check with the datatypes if matching.

Is this answer useful? Yes | No

September 12, 2006 13:46:40

nayana

RE: hI,i am trying to use a flat file and ...

I checked the datatype and precisions also...everything is same, but still i am not able to debug

i wonder why the same is working if i have oracle as my source

thanks

nayana

Is this answer useful? Yes | No

September 13, 2006 00:16:50

Motilal

Member Since: June 2006 Contribution: 13

RE: hI,i am trying to use a flat file and ...

The sme is working with Relational target.

Then, the problem lies only with the source.

So, Nayana.. you please again confirm for the existence of the file at the defined location and pre-view the data.

If it is still not working, then anybody would definitely like to know the schenario with full details.

Is this answer useful? Yes | No

Go To Top