DSXchange

Thanks Shaan,

That worked.

There is One way which we follow. 1. We call the Datasatge Jobs within the unix script . 2. As videsh suggested we use parameter.profile to set all the parameters except for the Passwords. 3 . Then using these parameters we get the Password from one of Server Wide script say get_pass. ex. we get the...

Let make things clear, "here the Target is the same sequential file"----> By that i mean that both the target stages refer to the same Sequentail file. Details : ex .Source Data is... ID Value----->Columns 1 10 2 20 3 30 Hash Data Id Value------------>Columns 3 300 23 2300 Then the target ...

Hi, I have a Job design in which source data is looked up against the data in the hash. The Requirement needs both the source records and matching record(based on key lookup) in the Target file. The Design which i built and is working fine is SRC---filter bycond a--->XFM1----->XFM2 using Lookup-----...

Hi , I am designing a job which requires , that for each record of source it will replicate the source record N times depending on some condition(ex.N=Number of matching Records found in Hash). Desgin i used is Src-----| |----------------Transform---------->Target Hash---| I tried with @outrownum .b...

Thanks for the help Guys,

It Worked with COmplete set option checked in the merger.

Hi, I used Merger stage as suggested using a dummy column and tried with complete set and inner join.But i was not able to get the desired result. File Src1 Column list----->a b dummmy 1 2 Z 3 4 Z 5 6 Z File Src2 Column list------->d e Dummy 11 12 Z 13 14 Z 15 16 Z The OUptut was a b d e Dummy Dummy...

Hi,

i tries using a dummy column and then performed the join on it.
But still i have not achieved the desired result.
Since Hash file behave like Tables.
Cannot we do cartesian Product on hash as on tables using the selection query like select Src1.a,Src2.b,... from Src1,Src2.

Hi, Our business Requirement states that we need to create cartesian product of 2 Sequentials files for loading. For Example, File Src1 Contains Coulmn Names--> a b c 1 2 3 4 5 6 File Src2 Contains Columns names ---->d e f 11 12 13 14 15 16 Then the output file shld contains Column Names a b c d e f...

Thanks Roy, Hi, In our Project we want to implement Control Loading,Logic as follows. 1> Divide the total rows in the staging table by n(constant) adn obtain n ranges(group of rows). 2> Then Load each of range seperatley in the target table. 3> If any of the row in the ranges fails ,the entire range...

Hi, In our Project we want to implement Control Loading,Logic as follows. 1> Divide the total rows in the staging table by n(constant) adn obtain n ranges(group of rows). 2> Then Load each of range seperatley in the target table. 3> If any of the row in the ranges fails ,the entire range is rollback...

Hi, In our Project we want to implement Control Loading,Logic as follows. 1> Divide the total rows in the staging table by n(constant) adn obtain n ranges(group of rows). 2> Then Load each of range seperatley in the target table. 3> If any of the row in the ranges fails ,the entire range is rollback...