DSXchange

Code mean ---the txt file that needs to be imported.

What are the feild defaults and final delimetrs option given in that satge?

Hello ,


while iam trying to import the txt fiel , i am getting the following error "The Valid datastage export file needs to be in Windows format i.e (Using CRLF Line terminators).Could you please help me how to get the code imported.

Thanks in Advance

hello .that correct.you are converting it to space .trim it also

the problem may be that you might have not defined the coulms corectly and also check the first line is column name as true if you have header record for your file

this might also be the issue
if there are more number of stages in a job

or in transformer the stage varibale logic is not handled correctly for decimal ,number datatypes i.e claculations

i t will be dufferent format based on invocation id or in some cases may be same

hi ,

In column A ,i am getting values like below

Coulm A columnB
1;2;3 ;

1|2|4 |

1~5~7 ~

So in column B i need to populate the delimiter

hi ,

In column A ,i am getting values like below

Coulm A columnB
1;2;3 ;

1|2|4 |

1~5~7 ~

So i column B i need to populate the delimiter .

hi ,

i need to find the delimiters in the value. and populate that delimilter in another column.How to acheive this?

Thanks in advance

@inRownum system variable works correctly only if the execution mode is sequential.duplicates are genertaed bcoz it the job is running on multiple nodes.

once after reading the different delimilter files , the idea is to write to dataset and from there to do tranformations accordingly.

Hi ,

for a data load ,i get two files source file with different format . how can i make my job generic to read the source files with has format diffrence .can some one help out to acheive this by schema file option.

Thanks in Advance

hi, I need to check wthether the Effective date is in between the Start date and end date cloumn. here is the example. Eff date Start Date End date 20091231 20081231 20111231 20071231 20081231 20111231 For the above records, i need to pick up the first record as Eff date is beetween the start date a...