Search results for query: *

You can use a normalizer transformation as solution to ur problem. Thanks

I haven't worked on MQ Series but to my best of my known knowledge I am replying to this. MQ Serires is a technology used for communicating with the MAINFRAMES. The technology is Queing your request to the MAINFRAMES & getting back your results. In Informatica it is used when the VSAM files in...

There are three reasons for the failure. 1. The dB server could be down at the time when the run started. 2.The DSN connection could not established.So try to recreate the DSN & again schedule for test load. 3.The Timeout for the connection would have occured due to network connection out...

Yes, I mean in the source & target transformation. Thanks VLN

This might happen for two reason if your mail server is not properly associated with the informatica server. or If the path given is not in the proper format in the sense forward slash for UNIX & backward for Windows. Depending upon where ur informatica server is installed. Regards VLN

I think the basic problem will be the primary key only that is available in the target. The same issue I have faced. The updation will happen if the source table & target table keys matches. Regards vln

Hi, Try this by going thru the wizard available in informatica it will be helpful for understanding the same.

This is because the informatica client is unable to contact thru network. The exact connection details are missing out like the connection type(TCP/IP...)Port number.. If you can provide all these I think it might work.

Hi, If you are trying to extract data from all the sources & then trying to dump into one single target then the below solution might workout. As you have said the structure is same what you have to do is just import one of the table into the mapping & do the necessary transformation & load...

hi, I think there won't be much issues by increasing the commit interval. But the potential problem if the session fails after loading some of the records say 25000 then it will rollback & even if the records loaded are correct u need to reload. But incase of 10000 then the no. of records is...

The First step would be to use a isnumber fuction in an expression & check whether the incoming data is valid accord. to your constraint(Like Numbers only). Then in a lookup transformation check whether the incoming number is valid account number. I think this would serve your purpose.