DSXchange

Have you tried the solutions given?

Can you be Specific?

You are getting all the Trans_Date other than the first one?
Is that your requirement?
If "Yes" then ,why did you drop the date of 25/10/09 for 1001?

make it a Clear post!!
Do you want filter the records with respect to the VALUES in the column or the sequence of the records?

Hope this will help,
1.Use Column Generator to generate a sequence
2.Use a stage Variable to get the MOD of the column divided by 2
3.Use Constraints to seperate the zero and Non-Zero value of the Stage Variable

Try this and post the feedback

Hope this will help,
1.Use Column Generator to generate a sequence
2.Use a stage Variable to get the MOD of the column divided by 2
3.Use Constraints to seperate the zero and Non-Zero value of the Stage Variable

Try this and post the feedback

Convert the Varchar Column to Decimal Datatype and Use maximum default length and Scale value

What is the data type of the data.......

I need to query the txt file and filter the records as per the constraints..
Do you have anyother idea in resolvimng this!!?

Thanks in advance,

Hi,
The Source System OS is Windows, and the DS Os is Aix unix,
The file size is huge of 3 GB. Its a one time run only

Let me know if you need anyother details,

Thanks,

Yes Syeed, My local machine is Windows. Can you tell me how to check the status of the FTP Service in my local machine

Thanks,

Thank you all. The problem is resolved

Thank you all, I gone through the manual and i searched in DSX for the FTP plugin details, I tried to work through it, Now i have some queries, Can i connect to the local machine i.e.,Localhost,? If so, What is the properties that has to be set as mandatory? I am having a 3GB file in my desktop of t...

Can anyone guide me in using the FTP Plugin Satge!!

Thanks,

It removes only the spaces, the source file has the "Tab Character" in it

Can you elaborate that Stage, since i have not used it before

Thanks in advance,