• 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

When should we use Sparse Lookup or Join in DataStage?

Admin June 14, 2020 DATASTAGE INTERVIEW QUESTIONS, DATASTAGE TUTORIAL
sparse-lookup-oracle-database-datastage
You have been working on DataStage and most of the times you have used Lookup stage for lookup data from reference link. Suddenly you heard about Sparse lookup and …
[Continue Reading...]

CurrentTimestamp(),CurrentDate() and CurrentTime() Functions in DataStage

Admin June 13, 2020 DATASTAGE TUTORIAL
CurrentTimestamp-currentdate-currenttime-datastage
CurrentTimestamp(),CurrentDate() and CurrentTime() functions are most useful functions in DataStage when we are dealing with the jobs to get the ‘current’ date and time stamp. Generally we use these …
[Continue Reading...]

Snowflake SnowPro Certification Sample Questions-2

Admin June 12, 2020 SNOWFLAKE CLOUD DATABASE
snowflake-snowpro-certification-sample-questions
This is continuation for previous post. True or false: A table in Snowflake can only be queried using the Virtual Warehouse used to load the data.TRUEFALSE Which of the …
[Continue Reading...]

Snowflake SnowPro Certification Sample Questions-1

Admin June 12, 2020 SNOWFLAKE CLOUD DATABASE
snowflake-snowpro-certification-sample-questions
Below are the sample questions for Snowflake certification. I have gathered total 30 questions and posted them in 2 posts. Please go through them and note that answers are …
[Continue Reading...]

CALCULATE SUM OF THE FIELDS AND RETURN RESULTS USING AWK COMMAND

Admin June 5, 2020 UNIX INTERVIEW QUESTIONS
Problem Statement: Student details are stored in the following format: “Roll no,Name,Scorel,Score2” Write Unix command to display the roll no and the name of all the students whose total …
[Continue Reading...]

Overview of IBM DataStage Flow Designer

Admin November 17, 2019 DATASTAGE TUTORIAL
IBM-DataStage-Flow-Designer
IBM DataStage Flow Designer is a web-based UI for DataStage, compared to DataStage Designer, which is a Windows-based desktop client. We can use IBM DataStage Flow Designer to create, …
[Continue Reading...]

Important things to keep in mind while deploying DataStage jobs in production

Admin November 16, 2019 Uncategorized
Do you think whatever you are migrating that will run properly in production? I am giving some of the things here. Of course this is not a final list. …
[Continue Reading...]

GET EXCEL FIRST SHEET NAME USING UNSTRUCTURED DATA STAGE

Admin November 15, 2019 DATASTAGE TUTORIAL
datastage-tutorial
We know we can give hard coded sheet name or parameterized sheet name while reading excel data from unstructured data stage. But the problem comes when you want to …
[Continue Reading...]

Posts navigation

Previous 1 2 3 4 5 6 7 8 … 17 Next

Like us on Facebook

Top Articles

  • Snowflake SnowPro Certification Sample Questions-2
  • Snowflake SnowPro Certification Sample Questions-1
  • HOW TO VIEW HIDDEN FILES IN WINSCP
  • 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 © 2025.
Theme by MyThemeShop 

 
Loading Comments...
Comment
    ×