Interview Questions Answers in Data Stage

Explain the scenarios where sequential file stage runs in parallel?

Answer

Scenario -
When we have to read the data from multiple files following the same format, we can enable this option (multiple reader)

thanks
www.datagenx.net

Is This Answer Correct ?

8 Yes

0 No

Question { Accenture, 6665 }

I have the following columns in the EMP table

Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981)

Desing a job such that the output contains the following

empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

Answer

For getting current age, simply do the calculation in transformer, or in SQL itself

http://goo.gl/atN4AT
www.datagenx.net

Is This Answer Correct ?

0 Yes

0 No

Question { 7643 }

hi everbody,
i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"

hi everbody,

i have a problem in my project..
Native Error Code: -407 "Assignment of a null value to a not null column"

i have no idea, what should i do..please help :(

Answer

Seq file can not hold the NULL value. Convert all Null values to '' in stage

http://goo.gl/atN4AT
www.datagenx.net

Is This Answer Correct ?

1 Yes

0 No

Question { IBM, 7436 }

which is the most complex job in your career? Please tell me answer?

Answer

There is no JOb as such complex or easy. It totally depends. This question has been asked to test your knowledge, that's it
Better whatever job you think is most complex for you. explain them

http://goo.gl/atN4AT
www.datagenx.net

Is This Answer Correct ?

0 Yes

0 No

Question { HCL, 3632 }

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

Answer

HI Madan
There should be a source team defined for your project. Getting data is totally depends what has been signed for your project. How they are going to send the data. It can be db, flatfile, mq, or xml.

http://goo.gl/atN4AT
www.datagenx.net

Is This Answer Correct ?

1 Yes

0 No

Question { TCS, 5244 }

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

Answer

Can you let us know what you have tried?

www.datagenx.net
http://goo.gl/atN4AT

Is This Answer Correct ?

0 Yes

1 No

Question { IBM, 4210 }

in datastage scenario this is sourec data i want this traget? tell me please?

source target
------- -------
Mohan,Prasad,Naresh Mohan
Prasad
Naresh

Answer

Use Pivot stage

Thanks
www.datagenx.net

Is This Answer Correct ?

2 Yes

0 No

Question { IBM, 7529 }

A 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.

Answer

You can try to put a copy stage with force=True propertly. It can inhance the performance

http://goo.gl/atN4AT
www.datagenx.net

Is This Answer Correct ?

0 Yes

0 No

Question { 7111 }

What is the difference between Link collector and Funnel Stages?

Answer

Both are doing the same task but Link Collector is server stage where funnel is parallel

Thanks
www.datagenx.net

Is This Answer Correct ?

0 Yes

0 No

Question { HSBC, 8624 }

which unix commands mostly used in datastage

Answer

All basic command of Linux

Is This Answer Correct ?

0 Yes

0 No

Question { NTT Data, 6292 }

In one project how many shared containers are created?

Answer

shared container is a reusable datastage code, so no restriction of its creation :-) You can create N no of it

thanks
www.datagenx.net
datastage4you.blogspot.in

Is This Answer Correct ?

5 Yes

0 No

Question { Polaris, 3442 }

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

Answer

Hi Bhavani, there should be source team who will send you the data for processing, It can be any db table or xml or flat files.

Thanks
www.datagenx.net

Is This Answer Correct ?

1 Yes

0 No

Question { IBM, 4273 }

how to load meta data

Answer

Go to column tab - Load - select metadata file

Thanks
www.datagenx.net

Is This Answer Correct ?

0 Yes

0 No

Question { 15267 }

What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

Answer

In lookup, there is condition, condition not met, lookup not met need to fill.
So, if you have given any condition on input column does not met -> that will be handled by condition not met
and if lookup (join keys) failed with ref data -> lookup not met

Thanks
www.datagenx.net

Is This Answer Correct ?

3 Yes

0 No

Question { 4444 }

How to move data set from one server to other?what are the steps to follow to do this?

Answer

First why you want to do that ?

You can try this -
Design a job like -
dataset1 -> copy -> dataset2

server1 and server2 should be connected
Bind server1 config file with first one and second with second dataset

But, this will not gurantee that data will be transferred successfully.

Thanks
www.datagenx.net

Is This Answer Correct ?

1 Yes

0 No

atul singh