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