DSXchange

I have tried both of the options above. But no luck yet.

Any more clues?

Hi Iam trying to create a generic job which generates sample records using row gen or column gen stage. iam using scheme file for defining metatadata in the stages. My problem is , i want to give defaults values for some columns. Iam not able to define default values in the schema files. I still wan...

Thank you

ArndW wrote:The answer is "sort of"; with the peek stage you can view selected data from each partition at runtime. ...

Thanks Srinivas,

My question was, is it possible to view partitions in any stages like sort or join.

These are not interview qs, i just started using PX, So just curious.

Sainath.Srinivasan wrote:Or orchadmin.

Are these interview Qs ? ...

Thank you all for your inputs. As mentioned by Sainath, if we go from 4 node to 2 node, the issue that may be raised is irregular size of partitions? My Another question is, How can I view datasets using a command. Thanks Deepthi Arnd, I know it is possible to read 2 node ds via 4 but may have issue...

Hi ,

Is it possible to view individual partitions of data in a job?

If yes , How can I view them?

Thanks
Deepthi

Hi
A dataset is generated on 2 nodes. Can I read the same dataset using 4 nodes? What kind of repartitioning should i have to implement?

How can i view the dataset that is created?

Thanks
Deepthi

Thank you for the information

nagarjuna wrote:There is also ENV variable to show PID ...APT_PM_SHOW_PIDS ( i am not sure about its name )

Hi ,

How can we implement vertical pivoting in datastage.

for eg:

we have

name mon sal
a jan 100
a feb 30
b jan 10
b feb 20


the output should be

name jan feb
a 100 30
b 10 20.

Please advice.

Thanks
Deepthi

Hi,

what are orch commands? are there commands same as what those that are run from datastage adminstrator? For what can we use these orch commands?

I am new to datastage Px. Please bear with me if this is a basic question.

Thanks
Deepthi

Thank you for the reply,

How do we know that all these process belong to one single job?

Thanks
Deepthi

nagarjuna wrote:ps -aeg | grep phamtom ---> will give the datastage background processes running

In director , you can use clean up resources

Hi

when a parallel job is running , it can have multiple instances, means multiple pids for one job.

How can we identify the pid's of the job and clear them from datastage director. Is there any other better way.

Thanks
Deepthi

Hi All, I am a newbie to quality stage. After going through couple of documents about quality stage i am completely confused. Please help me understand some basic things on quality stage. I sincerely appreciate your time. 1) Does quality stage has separate client and server components like datatsatg...

What is the maxium value that this key_mgt transform generates upto? Will it resets after the number is reached? Thanks Deepthi Is there anyway to compare the next value in a transformer before doing a insert? I am sorting data by three columns and comparing the previous values of each row to perfor...

Hi, I have a multi instance job that can be invoked with different invocation ids. If I run this multi instance job with invocation "Run-A", "Run-B" at the same time. say suppose these jobs take around 10 mins each to run. Will the locks on the jobs are shared by both or does the...