atul singh


{ City }
< Country > india
* Profession *
User No # 101401
Total Questions Posted # 1
Total Answers Posted # 31

Total Answers Posted for My Questions # 1
Total Views for My Questions # 15218

Users Marked my Answers as Correct # 37
Users Marked my Answers as Wrong # 4
Questions / { atul singh }
Questions Answers Category Views Company eMail

DataStage Scenario based Interview Questions

1 Data Stage 15218




Answers / { atul singh }

Question { IBM, 7136 }

if ename='subbu' while running job the job should be abort
how come?


Answer

Use the transformer stage to abort this job when empname is subbu


Thanks
www.datagenx.net

Is This Answer Correct ?    1 Yes 0 No

Question { 11209 }

Hi all, can u explain header and trailer records in file?
If a file has header and trailer /master-detail records how
will you read it in datastage?


Answer

Whenever there is any header and footer with file, those must identifiable like First line will be header or last line will be footer or by some column info (row type)

so if data follows first criteria, use unix or datastage head and tail to extract those

thanks
www.datagenx.net

Is This Answer Correct ?    2 Yes 0 No


Question { HCL, 3909 }

Hi all, explain one complex business rule that you had in your
project and how did you accomplish it using DS?


Answer

explain any scenario which you have faced

Is This Answer Correct ?    1 Yes 1 No

Question { IBM, 4256 }

How many jobs in ur project? Explain any complex job u have
done in ur project?


Answer

explain any jobs on which you have worked.

Is This Answer Correct ?    0 Yes 0 No

Question { Cap Gemini, 6127 }

how to create document in datastage?


Answer

please explain

Is This Answer Correct ?    0 Yes 0 No

Question { 7177 }

how many stages are there in Datastage... Please clarify
mee??


Answer

Open datastage, Go to Designer pallet ad count yourself.

Thanks
www.datagenx.net

Is This Answer Correct ?    3 Yes 0 No

Question { IBM, 22656 }

What is the version control how can i apply this in
DataStage can any one tell me the anser


Answer

What version control is already covered.
With 8.X onwards, we have to use 3rd party version control system it can be RCQ, SVN or your sharepoint also. But all these tools are quite manual as no one can connect to datastage and track the chnages.
We only need to manually upload the dsx and other info to maintain the version control.

Thanks
www.datagenx.net

Is This Answer Correct ?    1 Yes 0 No

Question { Polaris, 3423 }

How to lode data in sequntional files perform faster?


Answer

run the seq file stage in parallel

Is This Answer Correct ?    0 Yes 0 No

Question { IBM, 3535 }

How can we select pr retrieve the particular row in dataset
by using orchadmin command?


Answer

No, You can not.

Is This Answer Correct ?    0 Yes 1 No

Question { L&T, 11476 }

How to enter a log in auditing table whenever a job get
finished?


Answer

Now, for auditing Datastage jobs, you can use Operation Console database ODB to fetch the same details easy way

Thanks
www.datagenx.net

Is This Answer Correct ?    2 Yes 0 No

Question { ABC, 10274 }

Is there any possibility to generate alphanumeric surrogate
key?


Answer

You can generate AlphaNumeric surrogate key but not in surrogate stage, You need to put your logic in transformer

thanks
www.datagex.net

Is This Answer Correct ?    1 Yes 0 No

Question { 2590 }

How do you get log info into a file?


Answer

Use dsjob command

Is This Answer Correct ?    0 Yes 0 No

Question { 3373 }

How many Nodes configuration file you used in your last project?


Answer

It depends, generally, 4, 6 or 8

Is This Answer Correct ?    0 Yes 0 No

Question { UHG, 14864 }

Converting Vertical PIVOTing without using PIVOT stage in DataStage.
Ex:
DEPT_NO EMPNAME
10 Subhash
10 Suresh
10 sravs
Output:
DEPT_NO EMP1 EMP2 EMP3
10 subhash suresh sravs
2) How to implement Horizontal PIVOTing without using PIVOT stage.


Answer

Use transformer stage to achieve the same

Is This Answer Correct ?    2 Yes 0 No

Question { IBM, 3852 }

how to call sequential generator in datastage?


Answer

You can generate seq no by, column generator or transformer

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

Is This Answer Correct ?    0 Yes 0 No

 [1]   2   3    Next