DSXchange

Hi Team, We need below information regarding integration of DataStage with MapR: 1. Details on Integration of Datastage with MapR 2. Can Datastage natively use spark to run jobs on Hadoop? 3. Compatibility of Datastage with MapR 4. Compatibility of Datastage with Python/Hive HQL/Drill DSN Immediate ...

Apologies...DataBase is Oracle 10g, and I tried with Cast but data got truncated......as of now I changed the Query and removed the Union, but still the Question is open if we have to do such in future......

I am facing problem while using Column of datatype in source Query of Oracle. I Googled the same and found we cannot use UNION incase of CLOB while we can use UNION ALL, but by using UNION All we will get duplicates. We cannot apply distinct on CLOB column. Is there any way we can do union of CLOB c...

I checked we are not using any such action string parameter, only the schema name user name and pwd are parameterised, but the same jobs give error with index keys checked or without index keys checked.

I am using DB2 and sometimes during bulk load with replace mode I am getting error "Action String Parameter is not valid or is too long" . I am not sure why this error comes but when I use the same job and remove the index it runs fine , but sometimes it gives same error if index are remov...

Ok I will explain it more easily...The problem is we have source table and target table, we are loading target table with some transformation, but key columns are not derived just matched with may or may not data type conversion. now we have to match the source and target tables pairs and found out ...

Hi, I have pairs of tables metadata is partially matching and I need to compare data of every pair of table most preferably on key column as metadata is partially matching. In output I want the both the tables data count and the mismatch count and a flag column if comparision match or doesnot match....

I also faced this problem long back. But that got resolved I have to recall how? I think all the users have to restart there director.

There is other option apart from provided by other readers. You can use the control table and that should be populated initially at every run of your jobs/sequence and in your table you can add a column update_date whose value should be passed from DS transform DS job start date. Use pre SQL in your...

Hi, I have an issue related to communication resources in one of the jobs that I'm running on DS 8.0.1. as a result the sequencer fails. Is it related to configuration file?? Can I change the configuration file as of now it has 2 nodes and if its yes how? is it thro the manager-> tools->configurati...

Are these (this one and the "infinity rings" one) theoretical, or are they solving some real-world problem (and, if so, what problem)? ... Hi Ray, These are solving real-world problem. I cannot share the details publicly. Please share your details(private mail id or anything) so that I ca...

Thanks Jack, for presenting my problem in absolute same way which I want to be. Yes Link may come any way those are two way. I know its difficult but not impossible, we can use DataStage+SQL and try to solve and I have to solve. I have tried through Querry but still I reached half a way or no where....

Can anyone help me on the above issue.

I have installed server on VMWare and client on windows7.

If you draw a digram by using A_point and B_point and connecting them by using link column then you will get a figure of 8 or infinity symbol. I want those two loops as seperate loop means just update the ring name in column one so that it will not form the structure of 8. In orignal its a one ring ...