how to connect source to db?generally what r stages u used?
how to find the data is having delimiter format?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Stage Interview Questions

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?

3 Answers   Virtusa,


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,

3 Answers   TCS,


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.

1 Answers   IBM,


What is the command line function to import and export the ds jobs?

0 Answers  


wt is the difference between swith and filter stage

6 Answers   IBM,


hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer

1 Answers   Polaris,


WHAT ARE THE COMMON ERRORS IN DATA STAGE?

6 Answers   IBM, ME,


on how many columns we can perform aggregation in the Aggregator stage?

3 Answers   Reliance,


In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.

1 Answers   IBM,


Why do we use link partitioner and link collector in datastage?

0 Answers  


How many nodes supported by a one cpu in parallel jobs?

3 Answers   IBM,


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 .

2 Answers  


Categories