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

What are the environmental settings for data stage,while working on parellel jobs?

Satyam,

2 6718

Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?

2 5419

Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.

2 4149

how to design the change capture stage in(data stage parallel jobs) type 2

IBM,

2 42031

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

TCS,

2 6994

where we use column generator stage in real time scenario?

TCS,

5 21465

How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.

5 18622

when we will use connected Lookup & Unconnected Lookup

Wipro,

3 8192

which cache supports connected & un connected Lookup

Wipro,

1 4187

can we use sequential file as a lookup

Cognizant, Wipro,

7 17717

hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

Wipro,

1 5727

what is Audit table?Have u use audit table in ur project?

Accenture, Wipro,

3 19915

how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

Wipro,

2 6891

How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?

Wipro,

2 6361

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

TCS,

1542


Post New Data Stage Questions






Un-Answered Questions { Data Stage }

What is difference between server jobs & parallel jobs?

217


What are the main features of datastage?

233


What are sequencers?

238


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

614


What is the purpose of pivot stage and types of containers in datastage

213






describe the Steps to confiure a Qlogic switch

1485


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2301


Difference between in process and inter process?

236


Can you implement SCD2 using join, transformer and funnel stage?

559


How to clean the datastage repository?

234


What are datastage sequences?

227


I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

93


What is the flow of loading data into fact & dimensional tables?

218


Have you used Unstructured data?

437


What is use Array size in datastage

850