DSXchange

chulett wrote:Hmmm... you actually got a 3814 warning over a parameter of "type 111". Perhaps you can ask your Sybase DBA what that be. Also would be curious if you are using the SybaseOC stage or something else.

It is related to sybase datatype. I have resolved this issue. Anyway Thanks for your hint.

While sending a text file content to a sybase table, i got the below warning message. ALRT_Q..t_df: At row 1, link "ALRT_F" Sybase Server warning 3814 (severity 16): The parameter of type 111 did not have a valid value. Thing is, Job executed successfully..But the corresponding rows didn't...

I have six files in a folder. But it may increase in the future. ap_06052009_cons.txt ap_05052009_cons.txt ap_04052009_cons.txt ap_06052009_uma.txt ap_05052009_uma.txt ap_04052009_uma.txt so i used FOLDER stage to concatenate all the files into a single file. Because all files has the same meta data...

Hi All, I have 6 files. say for example FileName: 562009_cons_file.txt Content: Name Age Salary aa 35 80000 bb 42 95000 Now i want to get the name 'cons' from the file name and need to store it in the table. Table Structure: create table emp ( Name varchar(25), Age int, Salary int, Platform varchar(...

Who mentioned a Folder stage? If this is a different problem, you must start a different thread. Otherwise future searchers will be confused. i mean i have kept all those files in a single folder....so i used FOLDER STAGE... Can you tell me which stage that i have to use for this kind of scenario ?

ray.wurlod wrote:FileName: .\NUL
Filter Command: TYPE D:\Karthik\apl_*.txt ...

I am getting error message...

MTD_Performance..Folder_0.: DSD_DIROpen Folder Stage output link cannot have more than 2 columns.

MTD_Performance..Folder_0: DSD_DIROpen set &Folder& to

what .\NUL means?




[/img]

I have given like below FileName: #LoadFileDirectory#apl.txt I have six files. D:\Karthik\apl_c_28apr2009.txt D:\Karthik\apl_u_28apr2009.txt D:\Karthik\apl_c_27apr2009.txt D:\Karthik\apl_u_27apr2009.txt D:\Karthik\apl_c_26apr2009.txt D:\Karthik\apl_u_26apr2009.txt #LoadFileDirecotory# = D:\Karthik I...

ray.wurlod wrote:Well, sure, I guess anybody can.

Most of the experienced posters here refuse on principle to answer them.

There are some (official) sample questions on the IBM certification site.

can you give me the link?

Do all files have the same structure (metadata)? If so, probably the easiest approach is to use one Sequential File stage with a Filter command (such as TYPE file1 file2 file3... ) to capture ... Yes! All of them have the same structure. HDR0001 ENO, ENAME, SALARY, 1,aa,3000, 2,bb,1000, 3,cc,4000, ...

Do all files have the same structure (metadata)? If so, probably the easiest approach is to use one Sequential File stage with a Filter command (such as TYPE file1 file2 file3... ) to capture ... Yes! All of them have the same structure. HDR0001 ENO, ENAME, SALARY, 1,aa,3000, 2,bb,1000, 3,cc,4000, ...

1) Is there any command to know/get the datastage version? 2) What is the new features of Datastage 7? ( i.e From a developer Perspective) 2) What is the new features of Datastage 8? ( i.e From a developer Perspective) 3) What is the limitations of Datastage 7? ( i.e From a developer Perspective) 4)...

All,

I would like to write routenes. how to start to write routines?
i mean what is the first step to write a routine?

can anybody post the DataStage interview questions?

Hi All, I am newbie to this forum as well as to ETL concepts. I have a set of files ( the count may be 6,8 or 3. It depends.) stored under one folder(say for example D:\karthik). We don't know the exact file count in the folder. But the thing is we need to upload all those files into a single table....