I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
CTS,
7 23073Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
TCS,
3 9906i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?
TCS,
5 13249i have the source from Uk,north america how can i pass the data two tables based on the locations
2 5794I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
CSC,
4 14918hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz
4 8182disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
2257col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq
9 14988
How do you reject records in a transformer?
What are orabulk and bcp stages?
What is the project in datastage?
How to Remove Duplicate using SQL?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Explain Quality stage?
What are data elements?
Different ways a project can be moved to production ?...example ….export-import and Version control.
How to implement complex jobs in data stage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How to reverse the string using unix?
What is the command line function to import and export the ds jobs?
Describe stream connector?
What is the difference between an operational datastage and a data warehouse?
How can you write parallel routines in datastage PX?
