DSXchange

Hi All,

Finally i got msg saying Error Read timed out but using same credentials i am able to import data from IMAM and create new import connection in IMAM

Hi All, I have created an ODBC connection in Oracle and trying to validate same connection while connecting to IA under Configuration/Analysis settings but it is taking too much time to validate settings. Finally I am receiving timeout connection. When I tried to enter same credentials in Oracle it ...

Hi Folks,

I have one file Where it has n number of records , The Output i need first 20 records in first file and Other 20 records in second file and other 20 records in third file, The next 20 records will again go to first file like it has to go in a round robin way

There is no alternative option than using CFF stage as it reads these records and does the required output

i Think U can encrypt the password by using unix scripts which is easy way to do

Ur was a city in ancient Babylonia. The second person personal pronoun in English is spelled "your", not "ur". Please strive to maintain a professional standard of written English on DSXchange, not least because it helps those whose first language is not English. Also strive to ...

hi all,

i got stuck up with one requirement

i am getting a pipe delimited file
and in that i am getting records with pipe like this
abc|xyz|1|
how can we handle this in datastage?

appreciate ur response

i have got the desired output but for your information i am not taking about any business rules i just gave an example to my requirement so that it can be easily understood

hi friends,
I have I/p like,
empno sal
ravi 1000
raju 2000
srinu 3000
rao 500

i want o/p like
empno sal
ravi 1000
ravi 1000
raju 2000
raju 2000
raju 2000
raju 2000
srinu 3000
srinu 3000
srinu 3000
srinu 3000
srinu 3000
srinu 3000
rao 500
can any one explain how can i achieve this?

How can I convert a varchar data type into a numeric data type then insert it into a varchar field in a datatabase. For example, I need to clean up the leading zeros of this string "00000000000009700477" then insert it into a field with charvar data type. Note that I cannot change the char...

Hi pals, I am trying to do look up for masterdataset & update set (Both seq files) AND gave a reject link (peek )to merge. M_DATA: S_ID,FNAME,LNAME 1,MAHESH,VUPPALA 2,AVINASH,YEDULLA 3,VAMSHI,ANIMALLA 4,PRADEEP,VEJ 5,mark,john 7,A,B uPDATE_DATA: S_ID,MARKS,GRADE 1,90,A 2,75,B 3,60,C 4,40,D 7,50,...

Hi, I have the data in the format yydddffhhnnss format where ff is a sequence number. I need to convert that to date n time format. The datatype in DB is timestamp. Please help me. How can i convert that. What function will i use..? I used stringtodate for yyddd. But unable to get the data in right ...

Hi all, I have a record getting rejected due to additional delimiter found in name field. I have a record: "100774066","M "TORREZ, MRS"","21.82","7186551241 ","TORREZ, MRS","BD",/ /,"5576" The field "M "TORREZ,...

I am using DS 8.5 Parallel jobs on Windows and I have a incoming data with Line feeds and carriage returns and lots of extra spaces. I need to get rid of the Tabs, Line Feeds, Carriage returns and extra spaces so I can get as much as possible from the input into a 255 space. I tried using some Trim ...

Hi I'm using an left outer join in Join stage to join results returned from 4 Sybase tables and storing into a flat file. As this is an outer join there won't be data in few of the columns. For columns which doesn't have data I need to populate with 0 or spaces. I'm having problem in determining col...