Input Records: 123,Naveen 124,Joe 125,Gary 124,Joe 126,Mahesh 127,Bob 126,Mahesh 124,Joe We need to capture the duplicates from above data using Remove Duplicate stage along with any other stage. Expected …
You can automate the comparing DataStage jobs across environments or same environments using a diffapicmdline.exe file. This is provided by IBM and resides in C:\IBM\InformationServer\Clients\Classic directory. We need to pass …
wget is a utility for download files/content from the Web servers. It supports most of the protocols that are related to the Web such as HTTP, HTTPS, and FTP …
If we want to know what is wget command and its syntax then you can read our previous post. Read: wget command in unix In this post, we will …
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 …
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 …
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 …
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 …
