Search results for query: *

As far as working goes, the map is giving the right output. But, in the LOG I am able to see the folowing warning. TE_7004 Transformation Parse Warning; transformation continues... If you have any idea why this might be appearing, please help me out!

Ties! My bad man. One of the params in the LKP was a Date and I had to do NVL in the AGG before passing it as a parameter. That's the reason y it was failing. But thanks a lot for giving me tips for Verbose Log Mode. It helped me a lot in debugging! -Suchit

I got the Verbose option. Running it now... -suchit

Ok. How do I enable verbose logging ON? I run using the Workflow Manager and not by a script. Is the option available in the WF MGR? lemme check it out. And hope i get something outta this :) Thanks. -suchit

I am sure the IIF's are doing fine. The thing is, the data i am testing it on has all status=S and the same IIF structure is being used for another field in the AGG (only diff is that no LKP is called here) and the IIF is working perfectly fine. So, there's some prob with the LKP for sure. Any...

OK. I am using this to call the LKP from the aggregator: IIF ( STATUS='S', :LKP.LKP_GET_NAME(par1, par2), IIF (STATUS='B', IIF( SUB_STATUS='K' , :LKP.LKP_GET_NAME(par3, par2), :LKP.LKP_GET_NAME(par4, par3) ) ) ) The field in the AGG...

Yes, I am using an override query. And, yes, I have used the aliases. Actually I clicked on Generate SQL and the aliases were there. I just added the WHERE condition, tahts all. :( Phew! Can't understand whats going wrong!

Hi Ties, I did call the LKP with 2 parameters. But I cant understand why it returns a NULL. When I open the log file and copy-paste the script into SQL, I get values alrite. But, LKP doesnt seem to be working. Any pointers? Thanks, Suchit

Ties, hi Well I have called the LKP with 2 parameters. But I am not getting the expected column back. Any ideas? Thanks, Suchit

Hi, I am calling a LKP Transformation in an Aggregator like this: :LKP.LKP_GET_E_NAME The workflow is running and the target table is being populated perfectly except for the column that calls the LKP Transformation. What could be the reason? Thanks! su

Hi Ties, I thought a table needs to be connected to the SQ to enable the SQ query to reference it. Misconception. Thanks a ton for the help! -Suchit

Hi blom0344, Could you rather give me a solution as to how can I make things work in the above scenario? Thanks.

Just to add, the Select statement above is to be used in the Source Qualifier of <table_1>

Hi, I want to perform the following in Informatica: SELECT <field_1>, <field_2> FROM <table_1> WHERE <field_1>=(select <field_1> from <table_2>); I have only <table_1> as source in my map. Can I use the nested select statement? I think I cannot. If there's any way to use...

Hi, I was able to resolve this. Actually, if you need to restore a repository you need to use pmrepagent and not pmrep. so you can use, $ pmrepagent restore (options) where, (options) are -r <repository name> -t <database type> -u <database user name> [-p...

Hi, I was able to backup a respoitory into a backup file. But i am unable to understand how can I restore using the same backup file? The document here https://webserver.brandeis.edu/pub/Info/EpmThirdPartyAppDocs/repository.pdf says that pmrep restore is a command. But this manual is for...

Hi, I want to use pmrep and be able to backup and restore repositories from command-line. Can someone give nay pointers? Also, I have repository (say) REP1 which contains different folders (say) F1, F2 and F3 (as viewed in Rep Mgr tab). Is it possible to backup F1 only in REP1 from command...