Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: aravindv26
  • Order by date
  1. aravindv26

    Parameters

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

    Parameters

    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.
  3. aravindv26

    Lookup Override

    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...
  4. aravindv26

    extracting data from 1st line of flat file

    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...
  5. aravindv26

    Updating view which doesn't have keys

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

    Updating view which doesn't have keys

    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.
  7. aravindv26

    equivallent of Next_day function of oracle in Informatica

    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.
  8. aravindv26

    approach to sql query in informatica

    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...

Part and Inventory Search

Back
Top