DSXchange

But that will join me the first row of table 1 with the first row of table 2 and second row of table 2 with second row of table 2. Look at the below example for more details: Table1 -------------------------- Col1 || Col2 || Col3 1 || A || 0608 1 || B || 0708 1 || C || 0808 Table 2 -----------------...

Hi, I have a requirement where i have to map 1:1 relationship between 2 tables. below is the example of the data Table1 -------------------------- Col1 || Col2 || Col3 1 || A || 0608 1 || B || 0708 1 || C || 0808 Table 2 -------------------------- Col1 || Col2 || Col3 1 || A || 0615 1 || B || 0715 1...

Hi,

Could any one tell me how to define the multiple conditions in transformer similar to the IN clause in a database?

Which other stage apart from transformer will allow me to filter data using job parameters? I very well know that it can't be done using filter stage.

Thanks,

Would that have any of the sort method have any performance issue?

Hi, I have few below mentioned questions. could any one help me find the answers please? 1. What is the difference between inline sort and external sort? 2. If my data is sorted and then some lookups/aggregations are performed then will my data needs to be sorted once more or will it remain sorted i...

yes it is a string.

Yes it is

Hi,


I am trying to define conditions like the one's below.

Col1="XXXX" and #Var1#="YYY"

where var1 has got the value YYY, for which i am getting the error

Expected YYY in the schema.

can you help me define this conditions?

Thanks

Hi,

Would it be possible to build a custom stage around aggregator so as to take the inputs from the schema file instead of the pre-defined meta data????? I mean can i extend the stage to incorporate this feature????

Thanks,

I am not really sure about this solution, because incase, if you dont have access to the remote machine this will fail. can we not build a script to compile the job?

what could possibly be an alternative solution for this???

Will the same command work on unix/Linux machines? Currently i dont have access to the ds. I know its too basic to be asked, since i dont have the access to the server so I am a bit crippled.

THanks,
Hitman

Hi,

Is it possible to compile the job from the command line? If Yes, then what is the command?

Thanks,
Hitman

Hi,

Is it possible to pass a parameter instead of a column name so that the column value will be passed.

In transformer i need to map the columns dynamically. the column names will be passed as the job parameter and they could change when needed.

what could be alternative for this?

Thanks,
Hitman