Search found 34 matches

by pavi
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

How to do a change capture for a Slowly Changing Dimension

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
by pavi
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...
by pavi
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...
by pavi
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="...