Search found 45 matches

by leandrohmvieira
Wed Aug 08, 2018 1:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is there a way to restart a job from point of failure?
Replies: 7
Views: 4678

Sequence jobs does have some checkpoint functionality, which allow a sequence to restart from it.

Parallel Jobs and Server Jobs does not have any features like this. Can you provide some details of your problem?
by leandrohmvieira
Wed Aug 08, 2018 5:11 am
Forum:
Topic: How to transfer job design metadata to new host?
Replies: 3
Views: 3944

Thanks for your quick response Ray, but doing this will make my DataStage projects appears as they are residing on the IGC host itself, i think this will cause some confusion, there is no way to point to the real DataStage host?
by leandrohmvieira
Tue Aug 07, 2018 7:55 am
Forum:
Topic: How to transfer job design metadata to new host?
Replies: 3
Views: 3944

How to transfer job design metadata to new host?

Greetings experts. I would like to import Datastage jobs design metadata from a DS environment into a IGC environment, located in another host. I saw this post from metadatamen where he comments about importing design metadata between hosts. Can someone provide me some insights about how to do it? I...
by leandrohmvieira
Wed Aug 01, 2018 6:54 am
Forum:
Topic: IGC lineage for Datastage
Replies: 7
Views: 5991

Hey bhargav_dd, did you succeeded on this task? Can you share your solution?
by leandrohmvieira
Wed Jan 17, 2018 5:07 am
Forum: General
Topic: IIS 11.7 Installation: Enterprise Search questions
Replies: 7
Views: 7173

Thank you very much for the information Vincent, i will be looking for it when its available.
by leandrohmvieira
Tue Jan 02, 2018 4:56 am
Forum: General
Topic: IIS 11.7 Installation: Enterprise Search questions
Replies: 7
Views: 7173

intelcom wrote:ISES requires Linux. You can skip the installation of ISES.
Can i install in any linux distribution? Or only on RHEL?
by leandrohmvieira
Tue Jan 02, 2018 4:53 am
Forum: General
Topic: IIS 11.7 Installation: Enterprise Search questions
Replies: 7
Views: 7173

PaulVL wrote:Which package did you download? The windows one or the unix/Linux one?
Im using the windows installer (installing on a Win Server 2012)
by leandrohmvieira
Fri Dec 29, 2017 11:49 am
Forum: General
Topic: IIS 11.7 Installation: Enterprise Search questions
Replies: 7
Views: 7173

IIS 11.7 Installation: Enterprise Search questions

Greetings experts. I just downloaded IIS 11.7, and tried to install it on a windows server 2012 environment, but at ISES (Information Server Enterprise search) installation step, the installation program asks for an Red Hat host to install it. My questions are: 1 - Is now mandatory to have more than...
by leandrohmvieira
Fri Mar 24, 2017 5:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SCD TYPE 2
Replies: 2
Views: 3301

I dont think it's possible, SCD involves several variables that do not apply as common logic like DBSequence or filepath for each dimension, purpose codes, source data and transformations.
by leandrohmvieira
Mon Mar 13, 2017 9:15 am
Forum:
Topic: Import Stored procedure into IMAM/ IGC
Replies: 4
Views: 7481

Can you paste your CSV file here? So we can take a look for errors
by leandrohmvieira
Fri Mar 10, 2017 5:28 am
Forum: General
Topic: How to list all the jobs running on the Windows server
Replies: 2
Views: 3793

If you want just to see who's running, you can look into operations console, it have a list of jobs running, and you can filter it by project.

I think a DSODB query may also work as well.
by leandrohmvieira
Tue Mar 07, 2017 10:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Alter Table in Parallel Job
Replies: 4
Views: 4998

I think there is a way if there is some logic behind when drop and create columns, but IMO, this will be a little hard to maintain. Is there some special motive to drop and create columns on runtime?

Why not mantain ColA, ColB and ColC always on table and just fill it with nulls or dummy data?
by leandrohmvieira
Thu Feb 16, 2017 6:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: JDBC Connector Performance Tuning
Replies: 9
Views: 7813

Hello Satheesh, you can use partition reads on non-partitioned tables for sure, there are partions methods like round-robin which divides the table evenly. You just need to be aware of your ETL design, some stages need specific partition types to work, so if you have a complex ETL design, you data m...
by leandrohmvieira
Thu Feb 16, 2017 4:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: logic to calculate the missing record
Replies: 5
Views: 4628

There will be 1 row for each month? Or 1 row for each 3 first days of each month? If it does not fit in one of these scenarios i dont know how to guess the day number from a missing record.
by leandrohmvieira
Fri Feb 10, 2017 4:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sort and remove duplicates based on different keys
Replies: 1
Views: 3430

Sort and remove duplicates based on different keys

Greetings experts. I already searched for something similar here, but im not undertanding why i am receiving the following error: User inserted sort does not fulfill the sort requirements of the downstream operator remove_duplicates The business requirement is: i have 3 columns ID_HIST, DOC_TYPE and...