WebMar 12, 2004 · Answer there are two ways you can get. # 3 1. sort the data in descending. order and make true the. create key change column. 2. this can be done in. transformer stage at stage. variables. a. first sort the … WebOct 3, 2024 · DataStage is an ETL tool that extracts, transforms, and loads tool for Windows servers for data integration from databases into the data warehouse. It is used to design, …
Top 25 Datastage Interview Questions and Answers 2024
WebMar 22, 2024 · DataStage – Datastage Real time scenario source table name A A B B B C C D In source table data like this but I want traget table like this name count A 1 A 2 B 1 B 2 B 3 C 1 C 2 D 1 pls any one one . ... DataStage Interview Questions And Answers. 1) What is Datastage? A) DataStage is an ETL tool and part of the IBM Information Platforms ... WebJan 10, 2024 · The DataStage interview questions are classified into three levels based on difficulty as mentioned below: 1. Basic 2. Intermediate 3. Advanced Check out this video … solar panel for electricity india
Top 30 Shell Scripting Interview Questions And Answers for 2024
WebNov 13, 2024 · Answer: A,D. 2) Which three actions can improve sort performance in a DataStage job? (Choose three.) A. Specify only the key columns which are necessary. B. Minimize the number of sorts used within a job flow. C. Adjust the “Restrict Memory Usage” option in the Sort stage. WebHow can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records? WebOct 30, 2024 · DataStage Scenario Based Question – Separate Numbers and Alphabets. Admin October 30, 2024 DATASTAGE INTERVIEW QUESTIONS. DataStage scenario based question: There is a column having both numbers and alphabet, the requirement is to separate all the numbers in one column and alphabet in other column. solar panel for car charging