I think u might have "generated" the sql query in SQ Qualifer or u must have overridden it at session level.
In the first case, re-generate the query. The likely cause is that u must be having, say, 10 fields coming out of SQ, so the generated query would have 10 fields. But later u might have...
Hi, Thanks for your reply.
I dont know what happened but the session was re-run (as scheduled) and this time it completed successfully. I didnt do anything at all from my end. (May be i had upset the server god earlier... kidding).
Thanks everyone
Anant
Hey guys,
One of my session failed due to TM_6282 error. It states - Session fetch by DTM is not consistent with the session fetch by the Load Manager.
I dont understand this. I tried looking for its explanation at some places but with no success.
If anyone of you have ever encountered this...
Hi all,
I have a mapping that have a complex SQL for fetching data. It taked around 2 hours just to run the query and fetch the first record.
The Target i have is a flat file and is located in some other machine and i need to do a Direct FTP with no staging since the business users dont want...
Hi all,
I have numerous sessions in PRODUCTION which take anywhere from 30 seconds to 8 hours to RUN. i need to know which of the sessions are faring badly. To start with, i want to make a list of the size of the cache file created by each of the session during their run. I understand that these...
What you can do is (as suggested by SRI)...generate the SQL in the SQL Qualifier...which would be..
SELECT ID, VAL FROM TABLE1
NOW ...put a union clause there and just change the "FROM" table. So the query will become..
SELECT ID, VAL FROM TABLE1
UNION ALL
SELECT ID, VAL FROM TABLE2
Now ...
Hi,
There is no option to have "lookup" on a flat file in 5x, 6x...BUT...we can have an alternate way to achieve the functionality.
What u can do is to have the flat file as another source and perform a join between your original source and the FF using a joiner transformation (based on the key...
Hi All,
IS there a way by which we can generate subsequent numbers without using a sequence generator or oracle sequence. Somthing like...
var2 = :LKP.lkp_abcd......(returns some id number from target table)
var1 = 1000 ...
iff(condition1 = TRUE, var1, var2).
Now if "condition1" is TRUE, then...
This and other associated msgs u had posted below cannot be done with the help of infomrmatica. U have write unix scripts (grep on keywords like "rows loaded" etc.) which will read the sessionlog from the unix path where it is kept. Else there is one work around. All the session related...
See..for this problem all you need is a series of transformations...1. Dynamic Lookup 2. Router along with othertransformations like Seq Generator, etc.
First thing first, use dynamic lookup to find out whether the row exist in the target. If it does then u will get the value of "newlookuprow"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.