Submitted Questions

  • Scenario based question

    How to find if the next value in a column is incrementing or not for ex 100 200 300 400 If the curval greater than previous val then print greater if lesser print lesser For ex 100 200 150 400, Here 150

    karthick

    • May 30th, 2014

    Previous value in one stag_v1 and presend value in stg_v2 compare the two , if greater then stg_v1=stg_v2 and move to next value. else loop it.

  • What is the architecture of your Datastage project

    I came across this question many times in interview, In specific what can i answer..... Please help..

    rstrainings

    • Apr 15th, 2015

    we can say like there is a staging area to store the data in the form of tables, and then it transforms to ETL stage (Here we will do all the conversions,remove duplicates,joining,merging etc) then di...

    shiv

    • Jun 11th, 2014

    The above answer, is to architecture of Datastage, its not the architecture of project. Project architecture would be like: ***************************** You have: 1 Source--------> 1 Staging Area----...