DSXchange

Can any one please guide me...can we implement Arrays in transformer stage......

Sura ...Thanks For the info .but RCP is used when the Metadata is loded at least in on Source stage ...but my req: is with loading the Metadata in Source Stage Can we call the Metadata in to the source Dynamically and to propagate to next stage ...is it possible in DS ..???? 2) Number of records wil...

1) i have a case where i have to read the metadata dynamically ..Is it Possible in DS ..??? 2) I have a scenario where 100 records that are coming into Transformer and output of it is meeting my selection cretreia and getting out 75 records but i want to pick 25 records out of those 75 out randomly ...

Did any one came across the same issue ...plz help me out ...

i have a situation where a mainframe file is FTP'ied to BINARY format and we r calling using CFF stage ,here my issue was when i try to view data in CFF Stage it is showing me only 1 row and giving me an warning : Error executing View Data command: IIS-DSEE-TOIX-00179 <Complex_Flat_File_0,0> Import ...

Thanks , i did work what soumya suggested ....i got the desired output..Thanks all .i apperciate your response soumya.

All, I got stuck with small issue on JOIN Stage,below is the secnario which i am trying to work on : TABLE 1: DATA_KEY FIRST_DATA 1 A 2 B 3 C 2 D 4 E TABLE 2: DATA_KEY LAST_DATA 1 v 2 w 3 x 2 y 4 z DESIRED OUTPUT: DATA_KEY FIRST_DATA LAST_DATA 1 A V 2 B W 3 C X 2 D Y 4 E Z For some reason i am not g...

jwiles,

I apoloize for delayed reply,i used the column generator and used the seed property as suggested ...i'm able to get the desired ouput .

i have a question ..if i use the RND () or RANDOM () function how can i seed system time to it so that i can get random numbers for every run...?

No it is not different ..

actually i got the Random selction of data job done ,but for every run of the job i am able to get the same output random values ....
my criteria needs to get the different Random values for the same input DB2 file.....

Actually my requirement needs different random records for every run of same input DB2 file ,if i can shuffle the data coming from db2 .i would be able to get the random records out of it for every run for the same inout DB2 file..this is my scenario i have to work on ..

According to my requirment i have to generate different random records for every run by using the same input DB2 file...

how can i work it out ..Please help me out .

can you please elborate & explain the SQL query...Please.

Hey,

I have a situation where i have to shuffle the data for every run ..

and my source id DB2.. target is flat file ..

Please help me out on shuffling the input data in datastage..

I have a Question ,does RANDOM means every time if we run the Same I/P file should i be able to get different RANDOM records ...?Please clarify me..

Thanks for your Support jwiles & Ray .

I really appreciate your help ...