in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh
1 4374A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
3 7807Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C
3 10326Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers
4 6717Post New IBM Data Stage Interview Questions
What is a smart object?
What is the alternate way to click on login button?
How do you know if you have html5?
What is ms word format?
What is the bag?
What is the 5 by 5 rule?
What are guards in angular 2?
Can we use DISP=SHR in output file in JCL
Why do capital expenditures increase assets (pp&e), while other cash outflows, like paying salary, taxes, etc., Do not create any asset, and instead instantly create an expense on the income statement that reduces equity via retained earnings?
Define tool Manage Statistics in SQL Server 2000 query ?
Can we override a method by using same method name and arguments but different return types?
Explain the components of rdbms?
Why can't we use static class instead of singleton?
Tell me the difference between head, working tree and index, in git.
How can you Navigate from the DHTML application to another DHTML application? .