DSXchange

I didnt know datastage groups existed in Orkut and even yahoo. Nothing can beat this website, especially because of the supervision we get from our mentors

Look at the Read Method , "File Pattern". It accepts wild cards and hence can pick up all your files.
You can also give multiple file names.

how do i get Teradata in the Database vendor list? If you read the STP stage guide, you will see that the vendor section can also be populated during run time by parametrizing it. I was trying to get SQL Server Stored proc. to work. But IBM got back telling us that sql server wont work. But that wa...

Look at the ICONV function with conversion code "MCP". It will change the special characters to a point. Then you can use CONVERT() or EREPLACE() to replace to get rid of point.

Now you have a C funtion to do this. Why do you still want to go for a basic routine?
Isnt the C function workig for you? Or you are not able to get it to compile and linked properly?

You can also search on the error message and try different suggestion in those posts.

You can use a basic transformer if you want to raise a warning.
In a px transformer, you can abort a job. I am not sure if you can raise a warning.

I havent read it, but from the reviews it seems like a pretty fine book.

Same here. I am still in the building stages. Even today I read some replies and am like, "I had no idea". But whatever I do, whatever I build, it feels good as its your own hard work. A beautiful sense of pride and accomplishment. Even though its a small piece of code. But since its your own, its a...

You can set the Identity Insert On and Off in the before and after commands. But for that you need more permissions and usually dba's are ruluctant in giving that much access. Have a chat with your dba as Craig advised.

ray.wurlod wrote:Perhaps we should call you Igor?

I'd stick to DSGuruji, thank you

Did you try reading about "How to do it" in ODBC guide. It tells you everything. If it just has in IN parameter, you can also do it in the before/after sql of DRS stage.
Search is your best friend, search will also retrieve posts that will answer your question.

kduke wrote:I have been thinking about that book all week and how much it changed the way I think. It is funny Arnd and Ray have read it too.

I think I need to get a copy of that book as well then. Hopefully I'll be in the league of true Grurus.

Run the same query, only the sql query in your database stage and make the nv_year_month as a parameter. SELECT A.PERSON_KEY, A.EFF_DT FROM DBA.EVENT_F A, DBA.TIME_DT_D F, DBA.EVENT_D D WHERE A.TIME_DT_INTLGNT_KEY = F.TIME_DT_INTLGNT_KEY AND F.CAL_DAY_DT <= SYSDATE AND F.MONTH_INTLGNT_KEY <= ' #nv_y...

If you want timestamp difference then you can use KBATimestampDeltaDays by Ken.