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

source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?

Wipro,

2 4467

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

Wipro,

1495

how can we join one oracle & flat files ?

ME,

2 7294

1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...

iGate,

2 6023

2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?

1 4311

i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?

4 5902

eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000

HCL,

2 6010

1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran

HCL,

1 5288

1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?

1 4224

1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project

Accenture,

1 2612

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

1801

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?

2 5208

CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....

Wipro,

2 15034

In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..

2 8955

i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

TCS,

1 1903


Post New Data Stage Questions






Un-Answered Questions { Data Stage }

explain about citrix scheduling tool in datastage

1430


Is it possible to query a hash file?

1196


What is the difference between datastage and datastage tx?

220


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

1338


What is the purpose of interprocessor stage in server jobs?

1367






Explain how a source file is populated?

297


What are the types of views in datastage director?

584


Which algorithm you used for your hashfile?

245


What are the various kinds of containers available in datastage?

218


What are the types of containers?

260


how many rows sorted in sort stage by default in server jobs

3161


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

1358


Explain entity, attribute and relationship in datastage?

213


how can we create rank using datastage?what is the meaning of rank?

7673


How you can fix the truncated data error in datastage?

349