November 8, 2011 at 5:16 am
Hi,
this is the scenario i am trying can anyone help on this(its urgent)
204.243.130.5 - - [26/Feb/2001:15:34:52 -0600] "GET / HTTP/1.0" 200 8437 "http://metacrawler.com/crawler?general=dimensional+modeling" "Mozilla/4.5 [en] (Win98; I)"
204.243.130.5 - - [26/Feb/2001:15:34:53 -0600] "GET /logo1.gif HTTP/1.0" 200 1900 "http://www.clickstreamconsulting.com/" "Mozilla/4.5 [en] (Win98; I)"
204.243.130.5 - - [26/Feb/2001:15:35:26 -0600] "GET /articles.html HTTP/1.0" 200 7363 "http://www.clickstreamconsulting.com/" "Mozilla/4.5 [en] (Win98; I)"
The information we have in the above said records are as follows
h: The remote requestor IP
i: the remote server name via identification (typically -)
u: authenticated user unless required (typically -)
t: time in GMT
r: the entire text of http request
s: the returned http status code
b: no of bytes in the returned page
i: most recent referring URL
a:the requesting software type (usually browser type)
Create a ETL package which takes the input as above mentioned file and generate an output as follows.
Ouput should be
204.243.130.5,,,26/Feb/2001:15:34:52 -0600,"GET / HTTP/1.0",200, 8437, "http://metacrawler.com/crawler?general=dimensional+modeling","Mozilla/4.5 [en] (Win98; I)"
204.243.130.5,,,26/Feb/2001:15:34:53 -0600,"GET /logo1.gif HTTP/1.0", 200, 1900, "http://www.clickstreamconsulting.com/","Mozilla/4.5 [en] (Win98; I)"
204.243.130.5,,,26/Feb/2001:15:35:26 -0600,"GET /articles.html HTTP/1.0", 200, 7363, "http://www.clickstreamconsulting.com/","Mozilla/4.5 [en] (Win98; I)"
November 8, 2011 at 6:51 am
What is the question here? Do you have a specific problem somewhere where you need assistance?
Or do you just want someone to make the entire solution for you?
ps: take a look at the derived column component
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 13, 2011 at 9:02 pm
Hi,
Actually in derived column i used the substring and Instring ,and i got the solution but the problem is in source there are 3 records.
After running the ETL JOB i got only the single row in target...
can u help on this....
November 13, 2011 at 11:31 pm
maheshkrishnas (11/13/2011)
Hi,Actually in derived column i used the substring and Instring ,and i got the solution but the problem is in source there are 3 records.
After running the ETL JOB i got only the single row in target...
can u help on this....
What is your problem exactly? You have 3 rows in the source, but only 1 in the destination?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 14, 2011 at 2:42 am
Hi,
Actually the problem is My source & target is FLAT FILE. when i run the ETL it reading the 3 records in source as 1 record & sending that to Target
But it should read all the 3 and send to target as 3 records.
Example: Acv 2345.456 cbnvfr 200 5673
Acv 2346.567 vbndfr 200 3456
Acv 2347.567 dvbnfr 200 4216
But it reading like this
Acv 2345.456 cbnvfr 200 5673 Acv 2346.567 vbndfr 200 3456 Acv 2347.567 dvbnfr 200 4216
Expected output is
Acv, 2345.456,cbnvfr, 200, 5673
Acv ,2346.567, vbndfr, 200 ,3456
Acv ,2347.567, dvbnfr, 200, 4216
this is the problem
November 14, 2011 at 3:10 am
What have you configured as the row delimiter in the flat file connection manager?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply