Search found 18 matches
- 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...
- 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...
- 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 ...