1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category
Data Stage Interview Questions
Questions Answers Views Company eMail

what are the devoleper roles in real time? plz tell i am new to datastage....

Mphasis,

1626

what is normalization and denormalization

CTS,

2 12860

what is hash file

CTS, IBM,

2 4714

in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....

 4 6422

what is the custome stage in datastage? how can we impliment that one? plz tell me

Accenture,

1899

In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?

Polaris,

2 17137

source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

Patni,

3 8082

In which situations we can use normal and sparse lookup stages

IBM,

4 14059

i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?

IBM,

4 7699

what is the difference between 7.1,7.5.2,8.1 versions in datastage?

IBM,

3 8924

i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com

Wipro,

2 7698

i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?

Wipro,

2 5873

how to implement scd2 in datastage 7.5 with lookup stage

TCS,

5113

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

Wipro,

3 7587

in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?

Wipro,

2 8415

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

How do you find the number of rows in a sequential file?

781

Terminate Activity

831

What is difference between join, merge and lookup stage?

628

how to delete one row in target dataset

2582

Which warehouse using in your datawarehouse

1670




What is a datastage job?

608

What is the use of datastage designer?

627

To see hidden files in LINIX?

939

What are the stages in datastage?

628

How you Implemented SCD Type 1 & Type 2 in your project?

3684

What is datastage?

638

what is 'reconsideration error' and how can i respond to this error and how to debug this

2109

Have you used Unstructured data?

820

client know skid info?

1625

explain about citrix scheduling tool in datastage

1797

For More Un-Answered { Data Stage } Questions Click Here