DSXchange

I have similar requirement but not sure how to edit dsx file.could you please help on this

i do not want to use 4 joins.Just want to know can rewrite the logic some other way

1)one set of records col1='A',col2='B' and col3='C' for the above set i need to join based on 3 three columns 2)another set of records col1='D',col2='E' for the above set i need to join based on 2 columns 3)another set of records col1='e',col2='f' and col3='g' and col4='h' for the above set i need t...

I have table1(master table) consists of four columns(col1,col2,col3,col4).Another table table 2 is present.I have to join these two tables based on col1,col2,col3 for few records and col1,col2,col3,col4 for few records,col1,col2 for few records. currently i am using 3 join stages.Is there any way ca...

I do not find any option to select the Virtual table .could you please provide details where exactly i need to select

Thanks alot for input.How to give this virtual table as input while running columns analysis for a particular table.because i can see only Run now,sample ands chedule options

I found the option in IA for virtual column but i did not find any option related for virtual table.where exactly it is present?

chulett, could you please explain why we have to use without a "wait" option, sleep for a short period of time before triggering next job?

1)can i run column analysis by submitting a sql query because i want to restrict the data before running column analysis?If not how to fetch limited data without using sample technique?

It is slow for all tables and how to get below information without checking with admin

Is the table local/remote, indexed ... how big? Also share information about your hardware.

My admin is not willing to share that information as per company policies

When we are running column analysis on a table it is taking long time(more than 3 to 4 hours)even though volume of data is less on table.Not able to figure it out the root cause and from where i have start to find the issue.

let us say joba is running jobb is success jobc is success In that case also will it go to nested condition?If yes i did not convey the requirements properly from my side. all the three jobs should be in one of the two status (completed or aborted).Then only i need to check the condition in nested c...

@Bob Oxtoby

"It will work out which sequences and jobs need to be skipped or restarted"

Where we will mention which jobs needs to be skipped or restarted?

what will happen if joba is aborted and jobb and jobc are success if we use sequencer with all?whether it will go to nested consition

Joba

Jobb----------------->sequencer(any/all )----->nested condition------------>Jobd

Jobc




what i have to use for sequencer(any/all) and condition for nested condition?