DSXchange

Hi,

DSGetLinkInfo(hJob1,StageName,LinkName,DSJ.LINKROWCOUNT)

This will give you link count,you need to pass jobname,linkname and stagename.
You can either call this in after job subroutine or write a routine and call it.

Hi, When you export your job with above option,executable binaries will be included in job. E.g. BEGIN DSBPBINARY Identifier "V0S46_Mditof_001_MainJob_TSFM.o" B1 "01F70005534BF288000000000001E68A0078300200000911010B0001000000000000000100000240" B41 "0000000110000EF0000000011...

Hi,

Export job designs with executables: This option will export your Job design and binary executable files. It is useful for the environments where c++ compiler is not available. Sometimes organizations don't buy the compiler in all environments (like production) due to licensing costs.

Where is the interview?

Hi, It is cross join. Job design will look like below:- c-----Lnk1---->LKP1------>f File2-----> Copy(c) File1----->Filter Funnel(f)----->Dataset c----Lnk2----->LKP2------->f Use file2 as a source.In Copy stage pass both columns to link1 and link2. File1 will be input to filter stage which has two ou...

Hi,

You must check the Job stream code for TWS.I dont remember right now but if you give us job stream code,may be i can help.

Thanks everyone!

Issue is resolved.

Hi all, I have a requirement where i have preupdate,main loading job and post update. My requirement is to stored the current date before main job starts loading and pass this as a parameter to post update job in job sequence. To achieve this,i have used user variable activity stage between preupdat...

You can create a Test job with source as oracle connector stage and target as peek stage.

write below select query in connector stage:-


in coumn tab define ROW_CNT as bigint and check the result.

The connector was configured to run in parallel mode on 2 nodes, but the partitioned reads were not enabled. The connector will run in sequential mode. Source: Number of rows fetched on the current node: 21138554. Target: Number of rows inserted: 21,138,554 Hi, Your source connector stage is runnin...

make APT_PATTERN_USAGE_FILESET=true in your job.

I dont think file name column property gives you file name,if it is multiple files(File pattern).

Hi,
If upstream operator is running sequentialy and transformer round robin,then this formula will generate sequence number without any gap.

Hi,
If fields are same,what are you going to do?

In case you want incremental load,you can checksum stage.

Hi Sree,

You can do this with the help of transformer using stage variables.

Store your current value to stage variable.

CURR=InputROW
COMPARISION=if (PREV<>CURR) THEN 1 ELSE 0)
PREV=CURR

In the constraint define CMPARISION=0