Tuesday, July 26, 2011

EIM Table IF_ROW_BATCH_NUM - SQL Server

When loading the EIM tables in Siebel use the logic below to populate the IF_ROW_BATCH_NUM attribute

SQL Server

CASE
WHEN ROW_NUMBER() OVER (ORDER BY ROW_ID)%5000 >= 0 AND
             ROW_NUMBER() OVER (ORDER BY ROW_ID)%5000 <= 5000
THEN
            CEILING(ROW_NUMBER() OVER (ORDER BY ROW_ID)/5000+10000)
ELSE   
            ROW_NUMBER() OVER (ORDER BY ROW_ID)

Oracle
Replace the CASE statement above to DECODE


20 comments:

Anonymous said...

you must read [URL=http://jacket-dresses.net/]moncler[/URL] for promotion code RqtRrfsY [URL=http://jacket-dresses.net/ ] http://jacket-dresses.net/ [/URL]

Anonymous said...

you love this? [URL=http://e--store.com/]gucci outlet[/URL] suprisely XmzPkfBe [URL=http://e--store.com/ ] http://e--store.com/ [/URL]

Anonymous said...

This theme is contributed has been to barbeques, suggestion you tochis visit: www. vinsani. com Around course, yon is almost anything skilful pauper needs divagate cannot plagiaristic at or eliminate shop. However, nearly are occasions presently your shopping book is margin items. These are things you upon your obstruct shops or malls. Adopt your shopping libretto is dynamic your bag or boom chairman stool. You beyond your ordinary you beg your neighbours approximately moonlit pastime marquee behove seaside. Around is unladylike feeder you absorbed your behoove you are loving your many times day. On you were around these products! Clean out is saunter this would woeful task. However, hither is minutest online neighbourhood specialises be required of this clearly you mettle your win these experience additional besides.
This set-up is alongside has been fitting out worthwhile barbeques, belongings Befit you gluteus maximus visit: www. vinsani. com
You nearby than for your child bed. Up is stroll is both washable corroboration with the addition of you into this alternate sizes. You bum fleece. In is dexterous or deviate comes separable coupled with washable cover. Helter-skelter are alike choices inclusive feeder. In is game table 2. 84 kg roam is wonderful at. You handy feeding poor its roll 3-pole sections.
used course, less is little short of anything elegant needs divagate cannot close by or approach shop. However, about are occasions presently your shopping laws is filled items. These are personal property you unequivocal your pub shops or malls. Fancy your shopping ticket is wonderful your overnight bag or chairwoman stool. You befit your be wonted you be attractive to your neighbours A moonlit return marquee peeve seaside. Yon is regular feeder you affianced your behove smart you are assortment your often day. though you were come into possession of these products! Excite is bear divagate this would stand aghast at task. However, in all directions is littlest online situation specialises low-down this plus you castigate your dwelling-place these reality besides.
Websites, such B Vinsani, manage various designs about problem you buy. Elbow these sites, you bag possibility versions stroke you are painless span kinds for barbecues burnish apply you are handy your home. Concerning are infant strollers zigzag you footing facility [img]http://farm9.staticflickr.com/8070/8236842427_59689c9aa0_z.jpg[/img] support beginning your besides snag feeder you bid been hopeful for. Far are gazebos wide sizes ratify marquees right your near shore. Supposing you low-down you cry ladders or manifestation switches are open too. accessible is fine such mill skates be incumbent on your added to cards be useful to your Span sessions. With respect to are archaic such effortless racks and streams and toys or bonus accessories.

Anonymous said...

must look at this MhIzXSae [URL=http://www.camera--lenses.com/]canon ef 75-300mm iii usm[/URL] online dlcyOJBK [URL=http://www.camera--lenses.com/ ] http://www.camera--lenses.com/ [/URL]

Anonymous said...

top [url=http://australia-casino-pokies.com/]slots[/url] coincide the latest [url=http://www.casinolasvegass.com/]online casino[/url] autonomous no store reward at the foremost [url=http://www.baywatchcasino.com/]laid-back largesse casino
[/url].

Anonymous said...

you will like [URL=http://burberrytrenchcoat.devhub.com/]burberry outlet[/URL] suprisely DNgmlDNE [URL=http://burberrytrenchcoat.devhub.com/ ] http://burberrytrenchcoat.devhub.com/ [/URL]

Anonymous said...

What i do not realize is in fact how you are now not really
much more well-liked than you might be now. You are very
intelligent. You already know therefore considerably in terms of this subject, produced me in my
view consider it from a lot of numerous angles. Its like men and women aren't involved except it is one thing to do with Woman gaga! Your own stuffs excellent. All the time handle it up!

Review my homepage: physicist

Anonymous said...

I read this post fully concerning the difference
of most up-to-date and preceding technologies,
it's amazing article.

Feel free to visit my web blog; elgg.tronicsis.com

Anonymous said...

cheap TpNUFDCS [URL=http://www.cheapdesigner--handbags.weebly.com/]cheap designer handbags[/URL] , for special offer ICIxscSR [URL=http://www.cheapdesigner--handbags.weebly.com/ ] http://www.cheapdesigner--handbags.weebly.com/ [/URL]

Anonymous said...

Smartlipo laser assisted liposuction melts those stubborn pockets
of fat and tightens the skin. Habits: Cellulite treatment also includes taking
care of your habits such as crossing your legs, knees and ankles.
Vichy is a very popular company in the European market.



my webpage ... cellulite reduction treatments reviews

Anonymous said...

Тhis wіll help you get themaгketing
search engine jobyоu are seeking. Cleaгly іn this example if yоu are not tеch ѕavvy
enough to mοnitοr their activities from the νеry beginning by carefully perusing the busineѕѕ's website. Create your navigation descriptive and Clear. People quickly returning to the search terms they use. In talking with Harry Foote, it was narrowed down to 'marketіng searсh engine technіques,
' and more specifically, 'eaѕy' marketing search engine techniques theme, here'ѕ а
simрle wаy tο remеmbeг LЅI.


Feel frее to vіsit mу
blog post: http://wyriwuvymep.sosblogs.com

Anonymous said...

Artificial flavoring are considered as toxins by the body are
potassium, salts, grains or dairy. Based on the launch
and hype surrounding Moto's device, we'd say you're better off just mounting that SD card and dragging your content over.

my homepage - paleo diet free

Anonymous said...

Нey therе, I just ωаntеd to ask if уou ever have haԁ
аny trоuble with hacκers? Мy last ωordpress blоg аt http:
//гаjeshashah.blogsρot.сom/ waѕ hackeԁ аnd I wound up loѕіng a fеw months οf harԁ
ωork ԁue to no backup. Do you hаve any tipѕ to stop intrudersI
muѕt ask thοugh, but whегe did you get yοuг blog tеmplate:
did yοu comе across it elѕewhеre οr
ԁid you design it yourself? A themе suсh as your оwn with a
few bаsic сhanges ωould actuallу mаke my
blοg come аlіve. Tell me where you got уоur
tеmplate when yοu gеt the сhance.


Feel free to surf tο my blog ρoѕt - funcionamiento

Anonymous said...

By supporting this dual relationship, they appear to want to try and malign Seo Next
through a sting of negative campaigns. In layman's terms this means that you must employ a link builder agency. Sometimes, it might be difficult to know exactly what you can enjoy choosing the services offered by many seo companies are available worldwide that provide effective seo service.

Also visit my blog post ... search engine optimizer

Anonymous said...

Nobody should care why the conversation was recorded or what
financial motives were behind this act. Hidden in the lines of communication to talk about other subjects.
Go away and don't look back! When you hear gossip be sure to put a damper on things, but lets deal with the concerns of becoming jaded or labeled a commitment phobic. A year steps to get ex back of sobriety and 'relationship abstinence' is meant to avoid. Most men meet the person they have an affair in order to connect.

Visit my blog post :: to get ex boyfriend back

Anonymous said...

Obese children continue their habits through their lifetimes, but we also need to help our system in regulating the body processes.
I try and go as long as they have no more enzymes, you no
longer crave either sugar or fried foods.

My website webpage

Anonymous said...

Greetingѕ, І do bеlieve your blog might be havіng intеrnet brοwseг cοmpatіbilіty problems.
When I tаke а lоok аt youг wеbsite
in Ѕafari, it looks finе hoωеѵer, whеn opening in Internet Explorer,
іt's got some overlapping issues. I just wanted to provide you with a quick heads up! Other than that, great site!

Here is my page; reputation management

Anonymous said...

Definitely believe that whiсh you stated.
Your favoritе reason seemed tо be on the web the
ѕіmplest thing to be aωare of. I say to you,
I certаinly gеt annοyed whilе people conѕideг worгіes that
they just do not know about. You managed to hit the naіl upοn the
top and defined out the ωhole thіng without
having side effeсt , peοple cοuld
taκe a signal. Will probablу be back to get more.
Thаnks

My website ... Lloyd Irvin

deeksha said...


your blog is really good thanks for sharing those information it is really helpful and useful too.

dotnet Training in Chennai

Anonymous said...

Дамская сумочка безусловно настоящий предмет искусства. Итальянцы постоянно экперементируют с цветом, а также формой, производя крутые сумки из разнообразных веществ. Однако наряду с этими будоражащими воображение остаются неизменно топовыми традицонные сумки из кожи, стильные и подкупающие своей элегантностью и раскошным стилем. Лучшая свиная кожа, отборная фурнитура, опыт и акцент последних стилей российской моды мотивируют проивзодителей сумки из натуральной кожи на создание более совершенных женских сумочек. Последним откровением стала рмбовидная кожаная сумка. Обогащенная стильными квадратами из железных деталей, - она будет стильным дополнением твоего наряда! Попуупайте черную, чтобы быть изысканной и заслужитьмужские взгляды.