Search results for query: *

hey artie, i agree with the use of too much mouse usage, but we have some ways to use the keyboard too. its the way u adapt, to things, But i feel of the warehousing tools available, Informatica is one tool which is a fun to work with and a powerful one too. And i dont know about ver.8 as i...

hey ties, thats a good suggestion, but i have to create a parameter file, as per the guidelines, coz i dont know, for how many years i am going to need this,

hey artie, well, first of all, i dont know how many years they are going to require this and i am not able to determine how to check for a fiscal year change in a batch file. can u help me with the logic thanks

Hi blom, well i have created a router, and the mapping is complete, the data is getting loaded into the target correctly. and i have set the parameters for the start and end date. the problem is i have to automatize the creation of new file with the name of that particular fiscal year. It...

what i have done is, i have created a parameter file for suppliying the values for fiscal year start date and fiscal year end date. all i need to know is 1. How can i overwrite the file every night until the fiscal year changes 2. Once the fiscal year changes, how can i create a new file with...

Hi blom, i am working on a windows platform and the database is sqlserver. this is what exactly i have to do Only source rows for the current fiscal year are to be exported to an Excel-readable format every night. There will only be 1 file per fiscal year – that is the file will be overwritten...

hi all, I need to write a batch file to upload data from a relational source to a file target(actually i should overwrite the file every night). I should do this until the fiscal year changes and then i need to create a new file for the new year can any one help me with this thanks nithin

well guys thanks for ur view, especially blom, i have got the solution because of him. i did with the help of second approach told by blom. I didnt know how to implement that, but i tried and got it thanks anyways guys

The problem i have got is, i am not supposed to create views, and if u can help me with creating lookups

hey blom well i understood what u have told. well i even got the result from ur view method. i just got curious with the second approach and was trying for that. the view method is absolutely working and i have checked with that. I was trying the other method of creating two lookups. that is it

hi fearthelama, this is exact situation. I have a table called telmast, whose records are to be divided into mac and non-mac incidents. and the following is a condition. telmast is the source and i have to load into two files mac and non- mac the following is for mac. Lookup the MAC incidents...

hey blom0344, well i am just not getting how to do that. let me explain my problem first of all i have created two unconnected lookups for table2 and table3. then i created lookup ports as l_attribute2 for table2 and l_attribute3 for table3. Now i take a router transformation to divide the...

can u help me with the script

hi blom, can u tell me how this can be achieved

well fearthellama, i am not able to understand what to write the condition in the lookup. do u have any solution

hi all, I have to load a file with that days data every day, next day i should overwrite that file and load new data until the fiscal year changes. once the fiscal year changes i should create a new file for that year. If the current fiscal years file is FY2007 then the next year file should...

thanks blom for the answer, it really helped me. well sorry for asking this is there any other way to solve this

hi all, I have a source table which needs to be loaded into two targets, depending on a flag value 0 or 1. This flag value is stored in another table. Actually I need to lookup two tables, the source table and the table which contains the flag is linked by another table the logic is...