DSXchange

Thanks for the reply ray

i had extracted the data into dataset from dimension table and used

that one in my job . iam able to see the data in the dataset but its not

processing data into SCD stage

Hi,

i am not able to get the data from one input link of SCD stage .actually
that input dataset containing data but it is processing zero records

into SCD stage and also giving me a warning in directory "Lookup

table is empty".

can please help me

Thanks

Thank you somuch ArndW i got it

Thanks craig

where do we have to pass orchadmin in windows environment?

can we truncate or delete dataset in windows environment without using job?

Sorry for the delay .

its working perfectly thank you so much ArndW

Hi, My input data format is varchar:(08August2011) i want to convert out put as date (2011-08-08) i had written logic String To Date((Left(col,2):-:(If ((col,3,3)="JAN" Then "01" Else if (col,3,3)="Feb" Then "02"........upto December i had written and :-:Right...

Its working thanks to all i had written as ArndW said


Thanks

Hi ShaneMuir,

I am doing this in columderivation

my input datatype is varchar8

output is date

Thanks

Hi ArndW,

I am not getting what above logic is can please explain little bit

Try this one StringToDate(string,"%dd%mm%yyyy") Thanks vamsi but my input data format is if it aug 2 then the format is "2082011" if it is aug28 then the format is "28082011" for that i had return StringToDate(string,"%dd%mm%yyyy") and StringToDate(string,&qu...

Hi ray,

my input if it aug 2 then the format is "2082011"

if it is aug28 then the format is "28082011"


Thanks

Hi, while converting string to date iam getting warning "Data string '9122011' does not match format '%dd-%mm-%yyyy': the value for tag %yyyy has fewer characters than expected." because of above warning data of that field loading as ******** my input data format is(9122011) coversion logi...

ok Thanks ArndW

hi,

i have a dataset with 1,00,000 records. is it possible to read only 2,000

records from that at the time of reading??


Thanks