what is PUSH and PULL

chandra · Post by **chandra** » Thu Apr 13, 2006 3:36 pm

what is Push and PULL in Datastage

kcbland · Post by **kcbland** » Thu Apr 13, 2006 3:40 pm

I can't figure out your context but here goes: Pushing is your local server sending data away. Pulling is your local server bring data to itself.

If something pushes data to you, it means their server is sending data to your server. If you go get that data, you're pulling it over.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 13, 2006 4:23 pm

These terms are mostly used when describing how data arrive from other sources (often mainframes).

A PUSH means that a process on the other source initiates the transfer. DataStage will typically wait for a file to appear.

A PULL means that DataStage initiates the transfer (perhaps via an FTP stage or script) and can begin processing the data straight away.

These terms often appear on signs on doors, and it's surprising how many people get it right after only two tries!

chandra · Post by **chandra** » Thu Apr 13, 2006 7:55 pm

is the command we execute in mainfarme system or its a process .

I_Server_Whale · Post by **I_Server_Whale** » Thu Apr 13, 2006 9:32 pm

chandra wrote:is the command we execute in mainfarme system or its a process .

Your sentence doesn't make any sense. Push and Pull is just the terminology used as explained quite lucidly by our gurus above.

Thanks,
Naveen.

venugopal81 · Post by **venugopal81** » Thu Apr 13, 2006 9:52 pm

These terms we have used in SAP BW. We have used PUSH method when we need to send the data to SAP-BIW from Datastage. From SAP-BIW we need to extract the data we used PULL method. For this process we using SAP BW load packs..