Datastage scenario based questions with ans
WebMar 16, 2024 · Q #1) What is Datastage? Answers: Datastage is an ETL tool given by IBM which utilizes a GUI to design data integration solutions. This was the first ETL tool that gave a parallelism concept. It is available … WebDevendra kumar yadav Datastage blog, Dev Datastage, Dev datastage tutorials guide, datastage Online Training learning Material, Datastage Online Docs, datastage development Guidelines, DS Training, Information server datastage training, Websphere datastage issue and solution, Online datastage tutorials, Datastage interview …
Datastage scenario based questions with ans
Did you know?
Web1 Answers IBM, Hi This is Vijay How Can u Read the data from sequential file Parall'y? 5 Answers Semantic Space, How can we read latest records in a text file named file1.txt … WebApr 11, 2024 · DataStage Interview Questions I have the 10 input file like F1,F2...F10 then I need to load these 10 input files into 10 target Output tables like T1,T2...T10. Here is …
Web1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ? WebBe prepared with the below interview questions. 1.Create a job to load the first 3 records from a flat file into a target table? 2.Create a job to load the last 3 records from a flat file into a target table? 3.Create a job to load the first record from a flat file into one table A, the last record from a flat file into table B and the remaining …
WebApr 10, 2024 · DataStage Interview Questions 1.Without using stage variable how can we delete the duplicates using Transformer? 2.If we will remove duplicates using … WebDatastage Interview questions with Answers Datastage is an Extract, Transform and Load ( ETL ) tool from IBM and part of their IBM InfoSphere. Here I have collected more than 70 interview questions with their …
WebOct 29, 2024 · 1 Answer. Question 1: Can be solved with a transformer. Sort the data and use the lastrowingroup functionality. For Col2 just create a counter as a stage variable …
WebJun 17, 2024 · DATASTAGE SCENARIO BASED QUESTION – 2 : CITY NAMES AND DISTANCE BETWEEN THEM : PROBLEM AND SOLUTION Admin June 17, 2024 DATASTAGE TUTORIAL 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 … dickinson dorm university of delawareWebOct 21, 2024 · Now, here are the top 35 big data interview questions. These include a specific focus on the Hadoop framework, given its widespread adoption and ability to solve the most difficult big data challenges, thereby delivering on core business requirements. What is Big Data and What is it Used For? Watch on Top 35 big data interview … citric acid pickle stainless steelWebMay 4, 2024 · DataStage Interview Questions and Answers for Intermediates Q1). What is DataStage? DataStage is basically a tool that is required for designing, developing, and executing multiple apps to fill … dickinson dream.orgWebMay 4, 2024 · DataStage Interview Questions and Answers for Intermediates Q1). What is DataStage? DataStage is basically a tool that is required for designing, developing, and … dickinson dot phone numberWebFeb 11, 2024 · Here are DataStage interview questions and answers for freshers as well as experienced Datastage developer to get their dream job. 1) Define Data Stage? A … citric acid powder for saleWeb10 DataStage Interview Questions and Answers 1) What is Datastage ? 2) What are the differences between Datastage and Informatica 3) H... 20 Datastage Interview … citric acid powder flavouringWebJun 19, 2024 · Datastage Scenario Based Question – Separate Numbers And Alphabets. 2. Datastage Scenario: Reverse The Word. 3. Find Nth Highest Salary Group By Deptno … citric acid powder for rust removal