3) Sequential file contains data like
Empno ename sal
111 abc 2000
Trgt file:
Trgt1----111
Trgt2----abc
Trgt3---2000
Answers were Sorted based on User's Feedback
Different ways a project can be moved to production ?...example ….export-import and Version control.
how many datamarts we will use in real time project and when will use the datamart?pls send the replay early
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
How do u call shellscript/Batch file from DS?
Why do we use exception activity in Datastage?
I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
How many jobs in ur project? Explain any complex job u have done in ur project?
What are the types of views in datastage director?
How to RD using transformer?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Create 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
Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance