Search found 18 matches

by shank
Thu Aug 05, 2010 2:30 am
Forum: General
Topic: Datastage Challenge
Replies: 7
Views: 2271

Ok.. We are having a table which has the details of the table name and the column names which need to be compared. The table has 2 columns. COMP_FIELD and TABLE_NAME. This table would undergo change periodically. The sample data in the table would be like this... LAST_NM|CONSUMER_POLICY FIRST_NM|CON...
by shank
Thu Aug 05, 2010 1:28 am
Forum: General
Topic: Datastage Challenge
Replies: 7
Views: 2271

Datastage Challenge

Hi, Here is a scenario.. Kindly tell me we could do this using DS or not. The basic requirement is to compare data between current and history tables based on key columns. However both the table names and the columns to be compared will be dynamic. The table name and Key column will be passed to the...
by shank
Sat Jan 09, 2010 2:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Someone help
Replies: 2
Views: 1958

Someone help

I have 2 files as follows File1 Emp ID | Salary 1|30000 2|24000 3|9000 ... and so on. File 2 Lower Salary Value | Higher Salary Value | Grade 25000|30000|A 20000|25000|B 5000|10000|C ... and so on. My output file should be something like.. Emp ID | Grade 1|A 2|B 3|C .. and so on.. How can I achiece ...