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 Mike Lewis 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: *

  1. niloynibhochaudhury

    split records..

    Hi, I think i have found the solution whereby u can use 8 targets instead of 36 targets. The steps which I propose is in line with what u have done so far. 1. In the ROUTER use 8 different conditions, like, grp1: TRUE grp2: level > 1 grp3: level > 2 . grp8: level > 7 2. Then associate each...
  2. niloynibhochaudhury

    Writing to flat files using Informatica problem

    Hi Thanks for the reply.But I could not touch the way data is loaded into SQL Server. I have to FTP the file in a way which is understandable by the SQL Server. Thanks, Nils
  3. niloynibhochaudhury

    Information from database in email

    Sam, I think u can write a small mapping at the end of the batch and which writes the records into a small file. Then in the e-mail attach that file and send. Nils
  4. niloynibhochaudhury

    Writing to flat files using Informatica problem

    Hi All, I am FTP-ying a flat file using a mapping. Which is later loaded into a SQL Server DB. Delimiter is \007. The Informatica mapping server code page is ISO 8859... The client code page is WesternEuropean... Datamovement mode is ASCII. In the FTP-yed files the last column of the last row...

Part and Inventory Search

Back
Top