DSXchange

Try this DIGITS(DSLinkNN.ColName) in your tranformer for all numeric targets

Kewl

I want to strip away everything after : or ;
whats the function I can use and how?
Is their any in-built routine or custom routine?
Thanks in advance...
Kewl

Yes I can use DataStage whats the function that I can use?

No reply till now/...

Well I came up with a new requirement.
I need to strip away everything in parenthesis

I am using QS.
I have a URGENT requirements to strip of all the characters after ':' and ';' including.
Any gurus to guide me...
thanks in advance
Kewl,

It depends on the req. Is it taking any variables from the env? and in what kind of job/Stage?

You can use some code like within ticks e.g. `OS /UNIX SHELL CODE` in the jobs that will run at OS and get the output into job, try this...
Kommven

Anu, Solution underlies with the fact how the line terminates... The available 2 options you can specify are CR/LF binary will be ASCII or EBCIDIC knowing and specifying them will help or try combinations trail and error... in your scenario I strongly believe that its binary deliminated... Good luck,

I would be glad to someone would send me a copy of pdf's MetaStage user guide and related docs. This is time specific requirement and your immediate response will help me a lot. I appreciate your help in advance.

regards
Kommven

Email: kommven at GMail dot Com

Try simply
"TRIM(OCONV(@DATE,'D YMD[4,2,2]'),' ','A')"

I got the same situation and I used Trim("XXXX XX XX", " ", "A")

try it and let us know...

I like to use stage variables and I will implement it and let you guys know... All are of great help. Thank's everyone in person...

I heard that informatica has a built in module for handelling incremental aggregations.

So any built-in stage in DS?

Thanks for the help, I am trying @rownum

Kommu

What are you mentioning in mail server? By default it can be "mail" If you specify some other server address, there maybe a error. Sometime there maybe an alias for mail and mailx on your server. you shud achieve this goal by writing a script and invoking it by execute cmd. stage... goto p...

Can any one guide me for creating a job aggregating (taking avg) of a column in parts.

More in Detail ;-

name, qty1
a,5
a,3
r,6
y,2
i,5
q,3
o,4
t,3

Now I want to aggregate for every 5 rows, so the final ans is

Value
21
10

Anyhelp is highly appreciated...

Kommu

I can give you a simple definition for Data Cleansing. Its like Querying your DBMS with select col names so that you wont get unwanted data. Data Cleansing it at various levels at the least grain size is at row which can be achvd. by using simple Transformer job. At the highest level is at an aggreg...