Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Data Stage Interview Questions
Questions Answers Views Company eMail

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

Wipro,

2 4045

What is APT_DUMP_SCORE?

IBM,

2 15297

How we can convert rows to columns in datastage?

IBM,

4 19441

I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 5161

Demonstrate experience in maintaining quality process standards?

iGate,

1378

how can u find out the datastage job is running on how many nodes

IBM,

7 16246

how to capture rejected data by using join stage not for lookup stage. please let me know

Satyam,

3 14499

In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario

3 5017

What is process model?

1042

what is .dsx files

IBM,

3 9237

What are the unit test cases you used in your project?

CSC, HY,

1 8504

I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A

IBM,

3 4889

SOURCE LIKE I_D,F1,F2 --------- 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 O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y

4 4553

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 3760

How to get max salary of an organization using data stage stages........... can any body help me plz.......

Cap Gemini,

7 22541


Post New Data Stage Questions






Un-Answered Questions { Data Stage }

Triggers,VIEW,Procedures

343


What is the difference between informatica and datastage?

156


What is the roundrobin collector?

158


How do you generate sequence number in datastage?

165


Have you used Unstructured data?

363






Where the datastage stored his repository?

163


Explain datastage architecture?

172


What is the use of datastage director?

141


What are the types of containers?

181


What are the partitioning techniques available in link partitioner?

1191


What is the difference between in process and inter process?

179


If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

1178


How to reverse the string using unix?

1035


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

1469


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

3613