Hello Team,
Can any one please resolve this issue?The scenario is
After:
Key,Value
ABC,10
ABC,10
Before:
Key,Value
ABC,20
O/P:
Key,Value,Change code
ABC,10,Update
ABC,10,Insert
Expectation is both after records are updates.
Am I missing any thing
Search found 34 matches
- Thu Nov 21, 2013 6:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to do a change capture for a Slowly Changing Dimension
- Replies: 12
- Views: 3863
- Mon Jul 01, 2013 1:25 pm
- Forum: General
- Topic: Unknown value in command outpout varaible in Exec cmd activi
- Replies: 5
- Views: 2322
Thanks Chulett.. this command wc -l <filename> gives the output as <COUNT> <FILENAME> again I need to use an AWK to read only count but cat <FILENAME> | wc -l will give just count.But will keep in mind not use pipping frequently unless other wise required. Coming to my main issue,I tried to read the...
- Sat Jun 29, 2013 5:28 pm
- Forum: General
- Topic: Unknown value in command outpout varaible in Exec cmd activi
- Replies: 5
- Views: 2322
Thanks Chulett for your quick response. The requirement is to generate surrogate key. Every time my surrogate key starts generating from previous highest value I want to create/update the state file with the number of records which it had created until now. this approach will work even though some o...
- Sat Jun 29, 2013 12:13 pm
- Forum: General
- Topic: Unknown value in command outpout varaible in Exec cmd activi
- Replies: 5
- Views: 2322
Unknown value in command outpout varaible in Exec cmd activi
Hello techies, This is the scenario: Execute command activity-->Job activity Execute command activity=cat <filename> The above file is not present in the directory I need to write an if else statement in a job parameter in job activity as below: Max_param=If ( Execute_Command_0.$CommandOutput="...