• Connect With Us
  • Contact Us
  • Disclaimer
  • Start Here

Wings Of Technology

Menu
  • Start Here
  • Tutorials
    • IBM DataStage
    • INFORMATICA TUTORIAL
    • Unix
    • SQL
    • PL/SQL
  • Interview Questions
    • IBM DataStage
    • INFORMATICA
    • Unix
    • SQL
    • PL/SQL
  • Contact Us
  • Start Here
  • Tutorials
    • IBM DataStage
    • INFORMATICA TUTORIAL
    • Unix
    • SQL
    • PL/SQL
  • Interview Questions
    • IBM DataStage
    • INFORMATICA
    • Unix
    • SQL
    • PL/SQL
  • Contact Us

DataStage Macros (DSMacros)

Admin August 12, 2019 DATASTAGE TUTORIAL
DS Macros are built from Data Stage functions and do not require any arguments.   A number of macros are provided in the JOBCONTROL.H file to facilitate getting information …
[Continue Reading...]

Capture unique records (have no duplicates) in DataStage – Job Design – 2

Admin August 11, 2019 DATASTAGE INTERVIEW QUESTIONS, DATASTAGE TUTORIAL
DATASTAGE-SCENARIO-BASED-QUESTION-AND-SOLUTION
This is one of the most asked DataStage scenario based interview questions. I will solve this problem by taking some sample data. Input file: Sno,name,salary,rank 1,Naveen,10000,2 2,Joe,20000,2 3,David,30000,1 4,Richard,30000,2 …
[Continue Reading...]

A Simple PL/SQL Block

Admin August 10, 2019 PL/SQL TUTORIAL
Each PL/SQL program consists of SQL and PL/SQL statements which from a PL/SQL block. PL/SQL Block consists of three sections: The Declaration section (optional). The Execution section (mandatory). The …
[Continue Reading...]

Advantages of PL/SQL

Admin August 9, 2019 PL/SQL TUTORIAL
Block Structures:  PL SQL consists of blocks of code, which can be nested within each other. Each block forms a unit of a task or logical module. PL/SQL Blocks …
[Continue Reading...]

SecondsFromTime() Function in Transformer Stage in DataStage

Admin August 8, 2019 DATASTAGE TUTORIAL
SecondsFromTime function returns seconds portion of a time. Input: time Output: seconds (dfloat) Examples. If mylink.mytime contains the time 22:30:22, then the two following functions are equivalent, and return …
[Continue Reading...]

NextWeekdayFromDate() Function in Transformer Stage in DataStage

Admin August 7, 2019 DATASTAGE TUTORIAL
NextWeekdayFromDate function returns the date of the specified day of week soonest after the source date. The day of the week is specified as the full name, for example, …
[Continue Reading...]

HoursFromTime() Function in Transformer Stage in DataStage

Admin August 6, 2019 DATASTAGE TUTORIAL
HoursFromTime Function returns hour portion of a time. Input: time Output: hours (int8) Examples. If mylink1.time contains the time 23:30:00, then the following two functions are equivalent, and return …
[Continue Reading...]

FIND Nth HIGHEST SALARY GROUP BY DEPTNO FROM EMP TABLE IN DATASTAGE

Admin August 5, 2019 DATASTAGE INTERVIEW QUESTIONS
FIND-Nth-HIGHEST-SALARY-GROUP-BYDEPTNO-FROM-EMP-TABLE-DATASTAGE
This question can be answered easily in SQL in the following ways. Finding the nth highest salary in Oracle using rownum: Find nth highest salary in Oracle using RANK(): …
[Continue Reading...]

Posts navigation

Previous 1 … 4 5 6 7 8 9 10 11 12 13 14 … 17 Next

Like us on Facebook

Top Articles

  • WHAT IS THE DIFFERENCE BETWEEN NORMAL AND BULK LOADING IN INFORMATICA?
  • Snowflake SnowPro Certification Sample Questions-2
  • Snowflake SnowPro Certification Sample Questions-1
  • ORACLE : GET RECORD COUNTS OF ALL TABLES IN A SCHEMA
  • DataStage Scenario Based Interview Questions-1

Categories

  • DATASTAGE INTERVIEW QUESTIONS
  • DATASTAGE TUTORIAL
  • INFORMATICA INTERVIEW QUESTIONS
  • INFORMATICA TUTORIAL
  • PL/SQL INTERVIEW QUESTIONS
  • PL/SQL TUTORIAL
  • SNOWFLAKE CLOUD DATABASE
  • SQL INTERVIEW QUESTIONS
  • SQL TUTORIAL
  • Uncategorized
  • UNIX INTERVIEW QUESTIONS
  • UNIX TUTORIAL
Wings Of Technology Copyright © 2023.
Theme by MyThemeShop 

 
Loading Comments...
Comment
    ×