-
Reading multiple files through sequential file
what are the ways to read multiiple files from sequentila file if the both files are differnt
-
Improve performance using copy stage
How can we improve performance using copy stage
-
InvocationId
What is invocation Id? How to find InvoicationID? What is the need of Invocation Id?
-
Remove Leading Zero
How to remove leading zeros in data and transform data to target?
-
ETL Tools Lookup Stage
By using the Lookup stage we will combine the data from multiple table. By using join stage also we will combine the data from multiple tables. Then what is the need of Lookup stage?
-
Change File Attribute
How to change the attribute of a .dsx format file to make it read only?
-
Sequential File Stage
If are given a list of .txt files and asked to read only the first 3 files using seq file stage. How will you do it?
-
Sequential file with Duplicate Records
A sequential file has 8 records with one column, below are the values in the column separated by space,1 1 2 2 3 4 5 6In a parallel job after reading the sequential file 2 more sequential files should be created, one with duplicate records and the other without duplicates.File 1 records separated by space: 1 1 2 2File 2 records separated by space: 3 4 5 6How will you do it
-
-
What are Stage Variables, Derivations and Constants?
Stage Variable - An intermediate processing variable that retains value during read and doesnt pass the value into target column. Derivation - Expression that specifies value to be passed on to the target column. Constant - Conditions that are either true or false that specifies flow of data with a link.