DSXchange

Did you try to import admin variables to IGC? Maybe it not binding because of variable values in file path

Greeting experts. We are migrating some dimension jobs made in server job to parallel jobs. On Dimension tables there is a field called "LAST_UPDATE_DATE" which enters as null for new dimension rows and is filled with current timestamp when a type 1 update occurs. How do i implement this l...

I could not achieve a way to ignore this error, so i did a workaround solution, starting from JobInfo, which i have sure it exists. Here is the code: FOR Counter = 1 TO (COUNT(ParamDef,',')+1) STEP 1 ParamName = FIELD(ParamDef,",",Counter) StageName = FIELD(StageDef,",",Counter) ...

Greetings Experts, I want to ETL the rowcount of my jobs , and for it we adopted a dev pattern and created an after-job routine that get the values and inserts them in a table. But when routine is executed from a job that does not have the link, the routine aborts: LDWDim_Age..AfterJob (fatal error ...

Some stages are not compatible with lineage, maybe a unsupported stage are breaking the lineage flow:

check this here:
http://www-01.ibm.com/support/docview.w ... wg21685151

Are tables transparent? If they look transparent, its a virtual asset, on this case you must map connection to database on IGC. I followed this steps and was able to fix the problem: http://www.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.mdwb.doc/topics/t_data_connection_mapping...

IF this is a one time operation, craig got it. But assuming that you want to schedule this, just build a simple job like this: 1-import table definition of table2 2- Build this: connector------->transformer-------->connector 3- On connectors, load table2 definition. 4- On source connector, set gener...

Greeting experts. Im having problems in accomplishing this task: https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.ds.design.doc/topics/creatingatabledefinitionfrommetadatainthesuiterepository.html i can see and select tables imported to IMAM but the "create" but...

NLS configurations in Administrator client match our locale.

Should i open another thread do discuss this matter? Since is about another problem related to IIS console Information Analyzer project?

Thank you very much rjdickson, it was a locale problem, we are using PT_BR NLS, so decimal separators are comma separated, i changed the file separators mannualy and the report worked just fine. But this opens another question, there is a way to change IIS NLS Settings?So i dont need to change every...

Im just having the same problem now, can someone help me? :cry: Further information, i designed a job like this: Oracle Connector------->Investigate------->Sequential file Writing into a txt file. write mode set to overwrite. Write method set to specific files clean on fail true column names true(as...

Just curious.
Can someone show me a good example on how to use shared containers in server jobs?
Because i just cant figure out one. Some example where i can use it several times to reduce dev time

Thanks in advance.

Hello everyone, Im designing a job control process based on the following example: I have a seq: Job1 -> Job2 -> Job3 and a table on database REQ DEP Job1 - Job2 Job2 - Job3 If Job1 aborts, it will prevent Job2 and Job3 to execute and so on. To check jobs, i use a before and after subroutine to call...

There is a similar book for Server Job development?