If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records
TCS,
2 4206in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh
IBM,
1 3439i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
4 6689I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
2 5275A 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.
IBM,
3 6436input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2
HCL,
1 3820Create 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 8848
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are routines in datastage? Enlist various types of routines.
What are the partitioning techniques available in link partitioner?
Why fact table is in normal form?
What is ibm datastage flow designer?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
How do you import and export data into datastage?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is the difference between validated and compiled in the datastage?
What is the command line function to import and export the ds jobs?
Can you implement SCD2 using join, transformer and funnel stage?
Demonstrate experience in maintaining quality process standards?
What is the difference between hashfile and sequential file?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?