DSXchange

Nagraj, Examples in the developer guide are very self explanatory ones. Loop is a new feature , so definitely you ll see a no. of threads going forward, when developers will face any hurdles. When you are asking about loop (I mean logic here , not syntax), you can find at least 1 million code exampl...

@ Craig - Requirement is to read from dbf files , no access to Foxpro DB .
So I am not sure, will just an "ODBC" be a solution ?

@ Ray - I beleive 3rd party will definitely able to do , but client is insisting on xploring any feature in IIS can do that or not ?

Thnx
Saugat

I am interested to read foxpro dbf files ( created in Window) to read through DataStage ( in Linux) .

Can you please any one suggest me the steps /prerequisites for this process ?

Thank you .

Another Solution :-

1.Tick the Column (Which was causing the warning) as a Key .
2. Compile (Better Force Compile)
3. UnTick
4. Compile (Better Force Compile)

Warning will be vanished.

Thanks Ernie , these are relly useful tips.

Hi Ernie,

Thanks for this post . Can you please put some light on the best practices/tips across a typical data lineage project ?

It will be helpful if you can put some light if ETL is non- DS and DB is non-DB2.



Thanks
Saugat

why "the receiving party will have an heck of translation" ?
output is expected to 'n' numbers of characters/NULL separted by each pipe

Thanks Ray for the reply. But I guess , it is not the requirement . from input I will get a number (integer) .Lets say 'a'. value of 'a' can be anything between 1 to 'n'(Max Value, in this case I m saying 10). Now in output I want to generate a string (2n length). Lets call the output string as 'out...

Hi , I ve a input column which can give a integer value from 1 to 10 or NULL. I am interested to create a string of char(20) where I will like to put a 'X' on position value provided by input col , and rest as empty space delimited by |. For example , if input is 2 then output should look like '|X||...

Thanks

But Pdf file explains the way I ve don e,
Can you please explain bit

Thanks .
Saugat

yes
in C-Programing it shld be like this

swicth(RELEASE)
CASE R1: pass to output dataset 0
CASE R2: pass to output dataset 1
.........


So can you please suggest , I am doing right or not?

Hi I am using SWITCH stage in a job , and there are 3 cases are there .but when I m passing "user-defined Mapping" in "Case" I am passing case as case="R1"=0,"R2"=1,"IG"=2 , I am getting thefollowing error . SW_CIDN: Parse error on case string: "...

HI all Wish u a happy new year. I am getting these warnings (here I am giving some of the examples of the warnings but I am getting in all stages ) in each stage/attribute of a Job where I am using a Join stage, one Transfer and two modify stages and few dataset/Teradata PE. can you please help me t...

No . of Nodes in both jobs should be same .