Home
Videos uploaded by user “WingsOfTechnology”
How to delete duplicate records from a table in oracle
 
02:01
Let c how to remove duplicates from a table..I have one table here 'student' It has two duplicate records. 3 joe 4 robert These two records has duplicates. So I have to remove them. I can remove them using rowid functionality using one subquery. You can give different column names in GROUP BY clause. to identify the duplicate record. You can give just primary key values also. Duplicate rows are deleted now... Query used in video: delete from student where rowid not in (select min(rowid) from student group by sno,sname); Thanks for watching...:)
Views: 13648 WingsOfTechnology
Reading multiple files in sequential file stage using 'File Pattern' option in datastage
 
03:45
The Sequential File stage is a file stage. It allows you to read data from or write data to one or more flat files. The stage executes in parallel mode by default if reading multiple files but executes sequentially if it is only reading one file.In order read a sequential file datastage needs to know about the format of the file.If you are reading a delimited file you need to specify delimiter in the format tab.
Views: 12928 WingsOfTechnology
Simple Parallel job using Switch Stage in DataStage
 
03:08
This tutorial shows how to use switch stage in datastage. Switch Stage: The Switch stage is a processing stage. It can have a single input link, up to 128 output links and a single rejects link. The Switch stage takes a single data set as input and assigns each input row to an output data set based on the value of a selector field. The Switch stage performs an operation analogous to a C switch statement, which causes the flow of control in a C program to branch to one of several cases based on the value of a selector variable. Rows that satisfy none of the cases are output on the rejects link.
Views: 5089 WingsOfTechnology
Row Generator Stage in Data Stage
 
03:54
The Row Generator stage is a Development/Debug stage. It has no input links, and a single output link. The Row Generator stage produces a set of mock data fitting the specified meta data. This is useful where you want to test your job but have no real data available to process.
Views: 5739 WingsOfTechnology
Sample job on Sort Stage in Data Stage 7.5
 
02:34
This tutorial shows sample job on Sort Stage in Data Stage 7.5
Views: 2780 WingsOfTechnology
Simple DataStage Job using IF THEN ELSE condition in Transformer Stage
 
05:18
Assign a value that meets the specified conditions. If...Then...Else Operator Syntax variable = If condition Then expression Else expression variable is the variable to assign. If condition defines the condition that determines which value to assign. Then expression defines the value to assign if condition is true. Else expression defines the value to assign if condition is false. Remarks: The If operator is the only form of If...Then...Else construction that can be used in an expression.
Views: 6731 WingsOfTechnology
Simple Data Stage Job using Filter Stage and Overview of Filter Stage
 
08:21
The Filter stage is a processing stage. It can have a single input link and a any number of output links and, optionally, a single reject link. The Filter stage transfers, unmodified, the records of the input data set which satisfy the specified requirements and filters out all other records. You can specify different requirements to route rows down different output links. The filtered out records can be routed to a reject link, if required.
Views: 4924 WingsOfTechnology
CurrentTimestamp Function in Transformer Stage in DataStage
 
01:52
Returns a timestamp giving the date and time that the job runs in timestamp format. Input: - Output: timestamp
Views: 1107 WingsOfTechnology
Parallel DataStage Job Using Funnel Stage and Stage Overview
 
08:44
The Funnel stage is a processing stage. It copies multiple input data sets to a single output data set. This operation is useful for combining separate data sets into a single large data set. The stage can have any number of input links and a single output link. The Funnel stage can operate in one of three modes: Continuous Funnel combines the records of the input data in no guaranteed order. It takes one record from each input link in turn. If data is not available on an input link, the stage skips to the next link rather than waiting. Sort Funnel combines the input records in the order defined by the value(s) of one or more key columns and the order of the output records is determined by these sorting keys. Sequence copies all records from the first input data set to the output data set, then all the records from the second input data set, and so on.
Views: 2678 WingsOfTechnology
Adding Annotations and Descriptions for a DataStage Job
 
05:04
You can use annotations for a wide variety of purposes throughout your job design. For example, you can use annotations to explain, summarize, or describe a job design or to help identify parts of a job design. There are two types of annotations that you can use in job designs: Annotation: You enter this text yourself and you can add as many of this type of annotation as required. Use it to annotate stages and links in your job design. These annotations can be copied and pasted into other jobs. Description Annotation: You can add only one of these types of annotations for each job design. When you create a description annotation, you can choose whether the Description Annotation displays the full description or the short description from the job properties. Description Annotations cannot be copied and pasted into other jobs. The job properties short or full description remains in sync with the text you type for the Description Annotation. Changes you make in the job properties description display in the Description Annotation, and changes you make in the Description Annotation display in the job properties description.
Views: 1231 WingsOfTechnology
Creation of sample parallel job in IBM Infosphere DataStage 7.5
 
05:45
This tutorial shows how to create a sample parallel job in IBM Infosphere DataStage 7.5 version. Here used 2 sequential stages and 1 transformer to create a parallel job.
Views: 5468 WingsOfTechnology
Simple DataStage Job using Stage Variables in Transformer Stage
 
05:40
You can declare and use your own variables within a Transformer stage. Such variables are accessible only from the Transformer stage in which they are declared. Stage variables can be used as follows: They can be assigned values by expressions. They can be used in expressions which define an output column derivation. Expressions evaluating a variable can include other variables or the variable being evaluated itself. Any stage variables you declare are shown in a table in the right pane of the links area. The table looks similar to an output link. You can display or hide the table by clicking the Stage Variable button in the Transformer toolbar or choosing Stage Variable from the background shortcut menu.
Views: 10993 WingsOfTechnology
RANK Analytic Function in SQL with an Example
 
05:37
RANK() Analytic Function: 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 receives the same rank. For example, if the two top employees have the same salary value, they are both ranked one. The employee with the next highest salary is ranked number three, because there are two rows that are ranked higher. Therefore, the RANK function does not always return consecutive integers. The sort order that is used for the whole query determines the order in which the rows appear in a result set. PARTITION BY clause: Divides the query result set into partitions. The window function is applied to each partition separately and computation restarts for each partition. ORDER BY clause: Defines the logical order of the rows within each partition of the result set. That is, it specifies the logical order in which the window functioncalculation is performed. Query used in Video: select ename,sal,deptno,RANK() OVER(PARTITION BY deptno ORDER BY sal) from emp; Video Explanation: See here 6th row assigned the value '6',not '5' because 4th and 5th rows have same value for salary. Its the same for 12 and 13 rows also. we did not mention anything on OVER clause except ORDER BY. If you want apply RANK() by department wise, we can use PARTITION BY clause. PARTION BY works like GROUP BY in aggregates!
Views: 6201 WingsOfTechnology
How to copy one table records into another new table in oracle
 
02:19
we can copy a table data into a new table easily..with this query I'm going to create one new table student_new with the student table data. Query used in video: create table student_new as select * from student; Thanks for watching...:)
Views: 5026 WingsOfTechnology
ADD_MONTHS Function in SQL Query with Example
 
02:32
ADD_MONTHS(): The Oracle/PLSQL ADD_MONTHS function returns a date plus n months. Syntax: ADD_MONTHS( date1, n ) Arguments: date1 is the starting date (before the n months have been added). n is the number of months to add to date1. Example: Let's look at some Oracle ADD_MONTHS function examples and explore how you would use the ADD_MONTHS function in Oracle/PLSQL. ADD_MONTHS('01-Aug-03', 3) would return '01-Nov-03' ADD_MONTHS('01-Aug-03', -3) would return '01-May-03' ADD_MONTHS('21-Aug-03', -3) would return '21-May-03' ADD_MONTHS('31-Jan-03', 1) would return '28-Feb-03' Thanks for watching..:)
Views: 985 WingsOfTechnology
How to get Assistive Touch option in IPhone
 
00:46
This tutorial shows how to get Assistive Touch option in IPhone. If your home button is not working this is the best option for you,you can enable assistive touch option. It will work as Home button...etc
Views: 1040 WingsOfTechnology
Exporting Data From A Table in SQL Developer
 
02:51
This tutorial shows how to export the data from a table using SQL Developer tool.
Views: 29909 WingsOfTechnology
Simple job using remove duplicate stage in DataStage
 
06:18
The Remove Duplicates stage is a processing stage. It can have a single input link and a single output link. The Remove Duplicates stage takes a single sorted data set as input, removes all duplicate rows, and writes the results to an output data set. Removing duplicate records is a common way of cleansing a data set before you perform further processing. Two rows are considered duplicates if they are adjacent in the input data set and have identical values for the key column(s). A key column is any column you designate to be used in determining whether two rows are identical. The data set input to the Remove Duplicates stage must be sorted so that all records with identical key values are adjacent. You can either achieve this using the in-stage sort facilities available on the Input page Partitioning tab, or have an explicit Sort stage feeding the Remove Duplicates stage.
Views: 5217 WingsOfTechnology
How to check nodes number in your DataStage job by APT_CONFIG
 
01:15
This tutorial shows how to look in to nodes number in the APT_CONFIG file.
Views: 5830 WingsOfTechnology
BETWEEN AND Operator in SQL Query with Example
 
02:34
SQL BETWEEN ... AND Operator: The operator BETWEEN and AND, are used to compare data for a range of values. For Example: to find the emp details who have salaries between 2500 and 5000, the query would be like, select * from emp where sal between 2500 and 5000; The output would be similar to: EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ---------- --------- ---------- --------- ---------- ---------- ---------- 7566 JONES MANAGER 7839 02-APR-81 2975 20 7698 BLAKE MANAGER 7839 01-MAY-81 2850 30 7788 SCOTT ANALYST 7566 09-DEC-82 3000 20 7839 KING PRESIDENT 17-NOV-81 5000 10 7902 FORD ANALYST 7566 03-DEC-81 3000 20
Views: 1903 WingsOfTechnology
How to remove quotes to header record but have quotes to other records in DataStage
 
02:32
This tutorial shows how to remove quotes from header record. But data means all other records will have quotes.
Views: 1767 WingsOfTechnology
How to debug the data using peek stage in Data Stage
 
02:14
The Peek stage is a Development/Debug stage. It can have a single input link and any number of output links. The Peek stage lets you print record column values either to the job log or to a separate output link as the stage copies records from its input data set to one or more output data sets. The Peek stage can be helpful for monitoring the progress of your application or to diagnose a bug in your application.
Views: 5362 WingsOfTechnology
RANK Aggregate Function in SQL with an Example
 
01:40
RANK() Aggregate Function: RANK calculates the rank of a value in a group of values. The return type is NUMBER. Query used in video: select RANK(5000) WITHIN GROUP (ORDER BY sal) "Rank" from emp;
Views: 970 WingsOfTechnology
DateFromJulianDay Function in Transformer Stage in DataStage
 
03:38
Returns a date from the given julian day. Input: julianday (uint32) Output: date Examples. If linkname.julcol contains the value 2454616 then function returns the date 2008--05--29.
Views: 406 WingsOfTechnology
Sample Sequence Job in Data Stage
 
02:11
Designing a job sequence is similar to designing a job. You create the job sequence in the Designer, add activities (as opposed to stages) from the tool palette, and join these together with triggers (as opposed to links) to define control flow. Each activity has properties that can be tested in trigger expressions and passed to other activities further on in the sequence. Activities can also have parameters, which are used to supply job parameters and routine arguments. The job sequence itself has properties, and can have parameters, which can be passed to the activities it is sequencing.
Views: 16009 WingsOfTechnology
TO_CHAR(datetime) Function in SQL Query
 
03:59
TO_CHAR (datetime) : TO_CHAR (datetime) converts a datetime datatype to a value of VARCHAR2 datatype in the format specified by the date format. The following is a list of valid parameters when the TO_CHAR function is used to convert a date to a string. These parameters can be used in many combinations. YEAR Year, spelled out YYYY 4-digit year YYY Last 3 digits of year. YY Last 2 digits of year. Y Last 1 digit of year. IYYY 4-digit year based on the ISO standard Q Quarter of year (1, 2, 3, 4; JAN-MAR = 1). MM Month (01-12; JAN = 01). MON Abbreviated name of month. MONTH Name of month, padded with blanks to length of 9 characters. RM Roman numeral month (I-XII; JAN = I). WW Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year. W Week of month (1-5) where week 1 starts on the first day of the month and ends on the seventh. IW Week of year (1-52 or 1-53) based on the ISO standard. D Day of week (1-7). DAY Name of day. DD Day of month (1-31). DDD Day of year (1-366). DY Abbreviated name of day. J Julian day; the number of days since January 1, 4712 BC. HH Hour of day (1-12). HH12 Hour of day (1-12). HH24 Hour of day (0-23). MI Minute (0-59). SS Second (0-59). SSSSS Seconds past midnight (0-86399). FF Fractional seconds. Thanks for watching...:)
Views: 9442 WingsOfTechnology
Creating New Photo Album in IPhone
 
01:31
This tutorial shows how to Creating New Photo Album in IPhone
Views: 511 WingsOfTechnology
CurrentDate Function in Transformer Stage in DataStage
 
03:58
Returns the date that the job runs in date format. Input: - Output: date Use this function to add a new column containing the date to the data output by the Transformer stage:
Views: 2407 WingsOfTechnology
Create A New Table in ORACLE SQL Developer
 
03:51
This tutorial shows how to create a new table using SQL developer tool.
Views: 4461 WingsOfTechnology
Date type conversion from any date format to any date format in DataStage
 
04:30
Use the type conversion functions to change the type of an argument. StringToDate Returns a date from the given string in the given format. You do not have to specify a format string if your string contains a date in the default format yyyy-mm-dd. Input: string (string) [,format (string)] Output: result (date) Examples: If the column mylink.mystring contains the string ″1958--08--18″, then the following function returns the date 1958--08--18. StringToDate(mylink.mystring) If the column mylink.mystring contains the string ″18:08:1958″, then the following function returns the date 1958--08--18. StringToDate(mylink.mystring,"%dd:%mm:%yyyy")
Views: 4693 WingsOfTechnology
DaysSinceFromDate Function in Transformer Stage in DataStage
 
04:00
Returns the number of days from source date to the given date. Input: source_date, given_date Output: days_since (int32)
Views: 751 WingsOfTechnology
How to know Iphone configuration like modem firware,ios,IMEI,Model
 
01:13
This tutorial shows how to know Iphone configuration like modem firware,ios,IMEI,Model
Views: 1973 WingsOfTechnology
LOWER and UPPER Function in SQL
 
01:59
UPPER(): UPPER returns char, with all letters uppercase. char can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The return value is the same datatype as char. The database sets the case of the characters based on the binary mapping defined for the underlying character set. LOWER(): LOWER returns char, with all letters lowercase. char can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The return value is the same datatype as char. The database sets the case of the characters based on the binary mapping defined for the underlying character set. Thanks for watching...:)
Views: 1031 WingsOfTechnology
Difference Between RANK and DENSE RANK in SQL with an Example
 
04:48
Difference b/w DENSE_RANK() and RANK(): There is a small difference b/w DENSE_RANK() and RANK() Lets take one example! I will inlcude these two results in one query. Then we can find the diff easily. Upto 3rd rank both functions are working same..But 4,5 rows returing same salaries. So RANK() skipped rank-5 and jumped to Rank-6.But DENSE_RANK() returned consecutive ranks. This is the basic difference of RANK() and DENSE_RANK(). Thanks for watching...:)
Views: 2664 WingsOfTechnology
LENGTH Function in SQL Query
 
02:33
Length(): This function is used to calculate the length of a string or column in query. Here space is also treated as one more character. so the count is 10. Queries used in Video: select ename,length(ename) from emp; select length('oracle num') from dual; Thanks for watching..:)
Views: 1836 WingsOfTechnology
Simple job using Data Set Stage and overview of all options in Data Set Stage in DataStage
 
05:13
The Data Set stage is a file stage. It allows you to read data from or write data to a data set. The stage can have a single input link or a single output link. It can be configured to execute in parallel or sequential mode. What is a data set? parallel jobs use data sets to manage data within a job. You can think of each link in a job as carrying a data set. The Data Set stage allows you to store data being operated on in a persistent form, which can then be used by other InfoSphere DataStage jobs. Data sets are operating system files, each referred to by a control file, which by convention has the suffix .ds. Using data sets wisely can be key to good performance in a set of linked jobs. You can also manage data sets independently of a job using the Data Set Management utility, available from the InfoSphere DataStage Designer or Director.
Views: 4251 WingsOfTechnology
ASCII Function in SQL Query with Example
 
01:33
ASCII(): ASCII function returns the NUMBER code that represents the specified character. Sytax: ASCII( single_character ) PARAMETERS: single_character is the specified character to retrieve the NUMBER code for. If more than one character is entered, the ASCII function will return the value for the first character and ignore all of the characters after the first. Let's look at some Oracle ASCII function examples and explore how you would use the ASCII function in Oracle/PLSQL. For example: ASCII('C') would return 67 ASCII('T') would return 84 ASCII('T2') would also return 84 Thanks for watching...:)
Views: 1085 WingsOfTechnology
CHR Function in SQL Query with Example
 
01:36
CHR(): The Oracle/PLSQL CHR function is the opposite of the ascii function. It returns the character based on the NUMBER code. Syntax: CHR( number_code ) Here number_code is the NUMBER code used to retrieve the character. Example: Let's look at some Oracle CHR function examples and explore how you would use the CHR function in Oracle/PLSQL. CHR(116) would return 't' CHR(84) would return 'T' Thanks for watching...:)
Views: 786 WingsOfTechnology
Options avialable in Peek Stage in Data Stage
 
02:24
The Peek stage is a Development/Debug stage. It can have a single input link and any number of output links. The Peek stage lets you print record column values either to the job log or to a separate output link as the stage copies records from its input data set to one or more output data sets. The Peek stage can be helpful for monitoring the progress of your application or to diagnose a bug in your application.
Views: 1039 WingsOfTechnology
DENSE_RANK Analytic Function in SQL with an Example
 
04:10
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 receives the same rank. For example, if the two top employees have the same salary value, they are both ranked one. The employee with the next highest salary is ranked number two. This is one more than the number of distinct rows that come before this row. Therefore, the numbers returned by the DENSE_RANK function do not have gaps and always have consecutive ranks. The sort order that is used for the whole query determines the order in which the rows appear in a result set.This implies that a row ranked number one does not have to be the first row in the partition. PARTITION BY clause: Divides the query result set into partitions. The window function is applied to each partition separately and computation restarts for each partition. ORDER BY clause: Defines the logical order of the rows within each partition of the result set. That is, it specifies the logical order in which the window functioncalculation is performed. Query used in Video: select ename,deptno,sal,DENSE_RANK() OVER (PARTITION BY deptno ORDER BY SAL) from emp; Video Explanation: Here 6th row assigned with Rank-5. same for 12,13 rows. So this function always returns consecutive numbers. If you want apply DENSE_RANK() by department wise, we can use PARTITION BY clause. PARTION BY works like GROUP BY in aggregates!
Views: 1366 WingsOfTechnology
YeardayFromDate Function in Transformer Stage in DataStage
 
02:59
Returns the day number in the year from the given date. Input: date Output: day (int16) Examples. If mylink.mydate contains the date 2008-08-20, then the two following functions are equivalent, and return the value 233. YeardayFromDate("2008-08-20") YeardayFromDate(mylink.mydate)
Views: 254 WingsOfTechnology
Simple DataStage Parallel Job Using Funnel Stage
 
07:29
The Funnel stage is a processing stage. It copies multiple input data sets to a single output data set. This operation is useful for combining separate data sets into a single large data set. The stage can have any number of input links and a single output link.
Views: 1021 WingsOfTechnology