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

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

CTS,

2277

What is difference between 8.1 , 8.5 and 9.1 ?

IBM,

1 13928

How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

Caterpillar,

3 8703

What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 17634

what is set mapping in datastage??

ADP,

2 8597

My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

Wipro,

2 8728

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2013

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks

Cap Gemini,

5 10127

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

Cognizant, HCL, TIAA CREF,

8 21412

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

IBM,

1 7013

I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 9147

how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know

2 6428

Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del

HCL,

3 8611

My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.

Wipro,

6 9080

how to call sequential generator in datastage?

IBM,

1 2982


Post New Data Stage Questions






Un-Answered Questions { Data Stage }

Define APT_CONFIG in Datastage?

212


How do you schedule or monitoring the job?

200


How to implement complex jobs in data stage?

173


What are sequencers?

196


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

1471






What are the job parameters?

262


To see hidden files in LINIX?

474


What is the difference between validate and compile?

760


How do you generate sequence number in datastage?

198


What are the functionalities of link partitioner and link collector?

171


What are the areas of application?

218


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1076


How do you reject records in a transformer?

214


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

1530


How the ipc stage work?

206