• 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

WHAT IS DUAL TABLE IN ORACLE?

Admin July 28, 2020 SQL TUTORIAL
DUAL-TABLE-IN-ORACLE
In this post, you will learn about the Oracle DUAL table which is a special table used for evaluating expressions or calling functions. Now let’s dig into more on …
[Continue Reading...]

DIFFERENCE BETWEEN UNION AND UNION ALL

Admin July 16, 2020 SQL INTERVIEW QUESTIONS, SQL TUTORIAL
union-vs-union-all
In short, the difference between UNION operator and UNION ALL (UNION vs UNION ALL) operator is UNION gives unique results set in the output even though the combined result …
[Continue Reading...]

CC_MSG_LEVEL ENVIRONMENT VARIABLE FOR CONNECTOR LOG HANDLING IN DATASTAGE

Admin July 13, 2020 DATASTAGE TUTORIAL
CC_MSG_LEVEL-DATASTAGE
CC_MSG_LEVEL is a environment variable in DataStage and you can set this at job level and mostly it will be helpful to debug the issue that you are facing …
[Continue Reading...]

AUDIT LOG FILE IN DATASTAGE

Admin July 11, 2020 DATASTAGE TUTORIAL
audit-log-files-size-limit
Audit events are recorded in the audit log file on the DataStage Server Services tier. Logging in to or out of any InfoSphere Information Server client application or command-line …
[Continue Reading...]

DIFFERENCE BETWEEN ALL_TAB_COLS AND ALL_TAB_COLUMNS IN ORACLE

Admin July 10, 2020 PL/SQL INTERVIEW QUESTIONS, SQL TUTORIAL
ALL_TAB_COLUMNS and ALL_TAB_COLS are the views in Oracle that describes the columns of the tables, views, and clusters accessible to the current user. The only difference between two views …
[Continue Reading...]

DATASTAGE SCENARIO BASED QUESTION – 2 : CITY NAMES AND DISTANCE BETWEEN THEM : PROBLEM AND SOLUTION

Admin June 17, 2020 DATASTAGE TUTORIAL
DATASTAGE-SCENARIO-CITY-NAMES-AND-DISTANCE-BETWEEN-THEM
Problem: I have one file and it contains city names and distance between them. But there are duplicates, we need to remove those duplicates by using stage variables in …
[Continue Reading...]

DENSE_RANK() Analytic Function

Admin June 16, 2020 SQL TUTORIAL
DENSE_RANK-ANALYTIC-FUNCTION
DENSE_RANK calculates the rank of a value in a group of values. The return type is NUMBER. If two or more rows tie for a rank, each tied rows …
[Continue Reading...]

What is a Schema File in DataStage?

Admin June 15, 2020 DATASTAGE TUTORIAL
SCHEMA-FILES-IN-DATASTAGE
As a developer you always define the columns and their datatypes in ‘Column’ tab in each stage. Schemas are an alternative way to specify column definitions for the data …
[Continue Reading...]

Posts navigation

Previous 1 2 3 4 5 6 7 … 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
    ×