Search results for query: *

i forgot to mention is to use SetVariable to assign the value to mapping variable

Hi, As per my understanding I am giving the solution. use a mapping variable for this situation, and store the value as Built in variable value SESSSTARTTIME, and in the next run use the mapping variable value. I think that will solve ur problem. Aravind.

Hi all, In my mapping source is a flat file, in that i have a field called lastdateofqtr using which i am looking up into one table and finding out fiscal quarter, then i want to fetch Min(Today) and Max(Today) from the table using lookup and passing fiscal quarter. Using min and max values of...

Hi all, I have flat file in that 1st line contains Date which i need to extract and with the help of that i need to get fiscal week. how to get the date? Thanks in advace...

Yes, I am sure i want to update a view. That view is created using only one table.

Hi All, In my mapping i hv to update a view, but without keys informatica doesn't update the target. Views doesn't have keys, is there any alternate solution for updating the view. Thanks in Advance.

Hi all, I have a query which i have to map it into informatica, which is having next_day function, is there any equivallent of that function in informatica or any round about way. Thanks in advance.... Aravind.

Hi all, I have query is having 2 union statements, referencing 4 tables, and select statement is having sum functions, how to approach it in informatica. my sql query is: SELECT component_num,sum(psum),sum(dsum),sum(lsum) FROM ( SELECT 'P', component_num as...