Datastage scenario based questions with ans
WebDatastage Scenario Based Questions - Part 2 1. Consider the following employees data as source? employee_id, salary ------------------- 10, 1000 20, 2000 30, 3000 40, 5000 Q1. Create a job to load the cumulative sum of salaries of employees into target table? The target table data should look like as WebApr 22, 2024 · A comprehensive list of DataStage interview questions and answers can be found on this DataStage Interview Questions blog. We've posted a list of frequently asked DataStage interview questions and their comprehensive answers below. Rating: 5. If you're looking for DataStage Interview Questions & Answers for Experienced or …
Datastage scenario based questions with ans
Did you know?
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 … WebDataStage Scenario based Interview Questions Question Posted / datastage4you 1 Answers 13621 Views I also Faced E-Mail Answers DataStage Scenario based Interview Questions.. Answer / datastage4you Some Interview Questions and Scenario - http://www.datagenx.net/p/datastage-scenario.html …
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 … WebJun 19, 2024 · Datastage Scenario Based Question – Separate Numbers And Alphabets. 2. Datastage Scenario: Reverse The Word. 3. Find Nth Highest Salary Group By Deptno …
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 …
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 ?
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 … dwp db funding consultationWebDatastage 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 … crystal light tea flavorsWebMay 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 … dwp coventry addressdwp cwmbran addressWebOct 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 … crystal light tea drink mixWebIf you’re hiring for an entry-level ETL developer with up to 2 years of experience, consider using these beginner interview questions. 1. What are the key steps of the ETL process? Sample answer : While the abbreviation implies a neat, three-step process, ETL actually encompasses more steps. crystal light tea pitcher packetsWebApr 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 … crystal light tea nutrition facts