@@@@calling All Datastage Developers@@@@

[Jail Breaker]

[quote name='mrudhula99' timestamp='1345765389' post='1302369429']


i didn't mean that way... naku kuda adhem raadhuuu..

thelsukunteee enthe naa anpinchedhee... soo alaa react ayyanuu
[/quote]

dont be .. I was only kidding..

[mrudhula99]

[quote name='pandemkodi' timestamp='1345764975' post='1302369399']
nope single job antey seq lo activities add cheyyamani kaadu kada
[/quote]
invocation id ekkuva chesedhee sequencer lo nee kadha.....
let me know if I am wrong..

kani parellel job lo kuda use cheyyochu... job run cheeseappudu... everytime invocation id and tables marchatam kastam ani sequencer cheyyalemo ani anukunnnaa...

[pandemkodi]

[quote name='mrudhula99' timestamp='1345765537' post='1302369440']
invocation id ekkuva chesedhee sequencer lo nee kadha.....
let me know if I am wrong..

kani parellel job lo kuda use cheyyochu... job run cheeseappudu... everytime invocation id and tables marchatam kastam ani sequencer cheyyalemo ani anukunnnaa...
[/quote]
if u create multiinstance job then u can use that job to load multiple target tables

[pandemkodi]

[quote name='mrudhula99' timestamp='1345765537' post='1302369440']
invocation id ekkuva chesedhee sequencer lo nee kadha.....
let me know if I am wrong..

kani parellel job lo kuda use cheyyochu... job run cheeseappudu... everytime invocation id and tables marchatam kastam ani sequencer cheyyalemo ani anukunnnaa...
[/quote]
invocation id only seq jobss ee kaadu multiinstancejob create chestey aa job lo kuda ivvochu

[qwerty1204]

[quote name='mrudhula99' timestamp='1345765447' post='1302369432']
dhantlo antha pedha ga nerchukunedhee em ledhuuuu..

easy ga nee untundhe.... just click cheyyali anthee oka box..

really .... am not making fun of any...
[/quote]
mee lu taruvatha intaki ela cheyaloo evaru chepaledu


sequencer loo invocationID ni ee scenarios loo use chestamu?

[qwerty1204]

[quote name='pandemkodi' timestamp='1345765583' post='1302369442']
if u create multiinstance job then u can use that job to load multiple target tables
[/quote]

adhe baa howwwwwwww

like how/where can we change the src and target table names as we are running the same job 10 times

does the meta data has to be the same for all the source and target tables ?

[pandemkodi]

[quote name='arey ooo samba' timestamp='1345766797' post='1302369528']
adhe baa howwwwwwww

like how/where can we change the src and target table names as we are running the same job 10 times

does the meta data has to be the same for all the source and target tables ?
[/quote]
appudu manam 10 sets of parameters create cheyyalanukunta bayya ....should parameterize every table and db name
when u r running each time change the parameter..
metadata same vundalanukunta mama...lekapotey rcp enable cheyyali (inka peddollani raani)

[Silver_mani]

[quote name='arey ooo samba' timestamp='1345764177' post='1302369353']
ee interview questions ki answer enti baa

you job is running in multiple instances...and the task is to load 10 source tables (SRC1, SRC2 and so on are the source table names) to 10 target tables (TRGT1, TRGT2 and so on are the target table names) how can we do it using a single job?
[/quote]
If there are no transformations involved and it its direct load ....oka job tho 10 enti ....1000 tables kuda load cheyohu ... u have to write a shell script which generates sql ...nenu chesanu idi ..its works awsome

[pandemkodi]

online lo vundi

[color=#000000][font=arial][size=4]I think it can be done, calling same job 10 times, but this should be [/size][/font][/color]
[color=#000000][font=arial][size=4]totally a generic architecture. [/size][/font][/color]
[color=#000000][font=arial][size=4]Its quite complicated, since you need to create a script efficient enough [/size][/font][/color]
[color=#000000][font=arial][size=4]to run the job in the way we want. [/size][/font][/color]
[color=#000000][font=arial][size=4]Here is what you can do. [/size][/font][/color]
[color=#000000][font=arial][size=4]1. Enable the RCP Feature in Datastage. [/size][/font][/color]
[color=#000000][font=arial][size=4]2. Do not hard code any SQL, Table Name or Column Names anywhere in the job. [/size][/font][/color]
[color=#000000][font=arial][size=4]3. Since RCP is enabled you don't have to mention any column names. [/size][/font][/color]
[color=#000000][font=arial][size=4]4. Try sending Extraction SQL and Loading SQL as a parameter whenever a [/size][/font][/color]
[color=#000000][font=arial][size=4]job is to be run. [/size][/font][/color]
[color=#000000][font=arial][size=4]5. You have to save these 10 sets of parameters, in a way so that the script [/size][/font][/color]
[color=#000000][font=arial][size=4]can pick up the exact set of values needed and run the job to load that [/size][/font][/color]
[color=#000000][font=arial][size=4]particular table. [/size][/font][/color]
[color=#000000][font=arial][size=4]The same job can be run 10 times, to load 10 different table names, 10 [/size][/font][/color]
[color=#000000][font=arial][size=4]different SQLs calling the same script 10 times. [/size][/font][/color]
[color=#000000][font=arial][size=4]Hope this helps. [/size][/font][/color]

[pandemkodi]

[quote name='Silver_mani' timestamp='1345767643' post='1302369588']
If there are no transformations involved and it its direct load ....oka job tho 10 enti ....1000 tables kuda load cheyohu ... u have to write a shell script which generates sql ...nenu chesanu idi ..its works awsome
[/quote]
script pm pls ty

[Silver_mani]

[quote name='pandemkodi' timestamp='1345767703' post='1302369594']
online lo vundi

[color=#000000][font=arial][size=4]I think it can be done, calling same job 10 times, but this should be [/size][/font][/color]
[color=#000000][font=arial][size=4]totally a generic architecture. [/size][/font][/color]
[color=#000000][font=arial][size=4]Its quite complicated, since you need to create a script efficient enough [/size][/font][/color]
[color=#000000][font=arial][size=4]to run the job in the way we want. [/size][/font][/color]
[color=#000000][font=arial][size=4]Here is what you can do. [/size][/font][/color]
[color=#000000][font=arial][size=4]1. Enable the RCP Feature in Datastage. [/size][/font][/color]
[color=#000000][font=arial][size=4]2. Do not hard code any SQL, Table Name or Column Names anywhere in the job. [/size][/font][/color]
[color=#000000][font=arial][size=4]3. Since RCP is enabled you don't have to mention any column names. [/size][/font][/color]
[color=#000000][font=arial][size=4]4. Try sending Extraction SQL and Loading SQL as a parameter whenever a [/size][/font][/color]
[color=#000000][font=arial][size=4]job is to be run. [/size][/font][/color]
[color=#000000][font=arial][size=4]5. You have to save these 10 sets of parameters, in a way so that the script [/size][/font][/color]
[color=#000000][font=arial][size=4]can pick up the exact set of values needed and run the job to load that [/size][/font][/color]
[color=#000000][font=arial][size=4]particular table. [/size][/font][/color]
[color=#000000][font=arial][size=4]The same job can be run 10 times, to load 10 different table names, 10 [/size][/font][/color]
[color=#000000][font=arial][size=4]different SQLs calling the same script 10 times. [/size][/font][/color]
[color=#000000][font=arial][size=4]Hope this helps. [/size][/font][/color]
[/quote]


Exactly ...ide process

[Silver_mani]

[quote name='pandemkodi' timestamp='1345767734' post='1302369598']
script pm pls ty
[/quote]
nenu bayitki veltunna mama ..repu chesta k naa

[pandemkodi]

[quote name='Silver_mani' timestamp='1345767830' post='1302369607']
nenu bayitki veltunna mama ..repu chesta k naa
[/quote]
kk mama trivikram gif vesko

[qwerty1204]

[quote name='Silver_mani' timestamp='1345767643' post='1302369588']
If there are no transformations involved and it its direct load ....oka job tho 10 enti ....1000 tables kuda load cheyohu ... [b]u have to write a shell script which generates sql[/b] ...nenu chesanu idi ..its works awsome
[/quote]

shell scripting antenee...

kasta adhi entoo seffu baa[img]http://www.andhrafriends.com/uploads/gallery/album_15/gallery_24383_15_128369.gif[/img]

[pandemkodi]

[quote name='arey ooo samba' timestamp='1345768653' post='1302369695']

shell scripting antenee...

kasta adhi entoo seffu baa[img]http://www.andhrafriends.com/uploads/gallery/album_15/gallery_24383_15_128369.gif[/img]
[/quote]
mama neeku ft vachindi gaa malli interview endi