How we read comma delimiter file in sequential file stage and how we can remove the header and footer from a comma delimiter file?
Say I have 5 rows in a source table and for each rows 10 rows matching in a lookup table and my range is for lookup is 9 to 99. What will be the row count in output table?
I have a source file having data like: 10 10 10 20 20 20 30 30 40 40 50 60 70 i want three output from the above input file, these output would be: 1) having only unique records no duplicates should be there. Like: 10 20 30 40 50 60 70 2) having only duplicate records, no unique records should be there....
Suppose I am having a source file and 3 output tables and I want first row to be written to first table second row to second table, third row to third table likewise how can we achieve this using datastage without using partitioning?
Input file a contains12345678910input file b contains6789101112131415output file x contains12345output file y contains678910output file z contains1112131415how can we do in this in a single ds job in px ?....Could you please give me the logic to implement ???
How can we load three different flat files(1 file .Txt,2 file .Csv,3 file XML) to sequential file at a time?
How to get top five rows in datastage? I tried to use @inrownum,@outrownum system variables in transformer..But they are not giving unique sequential numbers for every row...Please help! thanks in advance!!
I have explored all the available functions in the transformer stage, but could not find the exact function to get the last day of the current month. Can you please show me which function is available for this logic.