how to connect source to db?generally what r stages u used?
how to find the data is having delimiter format?
I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?
Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,
in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.
What is the command line function to import and export the ds jobs?
wt is the difference between swith and filter stage
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
on how many columns we can perform aggregation in the Aggregator stage?
In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.
Why do we use link partitioner and link collector in datastage?
How many nodes supported by a one cpu in parallel jobs?
Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .